I have imported a cvs file that contains a field (Total Service Time) that has the number of hours and minutes someone worked on a particular issue.
The format of the field is =TEXT("0:16","[h]:mm"). I have tried converting the field to a number but it does not add up correctly.
I am trying to work out how I can "sum" this up to see the total time each person has worked.
Ultimately I would like to create a pivot table so I can see how much time each person has spent.
My data set looks like this
| Summary | Resolving User | Total Service Time |
| Please raise assyst on travel order 400162235 - Cathcart and assign to Dave Kearns | Person 1 | 0:16 |
| VFX TRAVEL - 400170543 | Person 1 | 0:18 |
| 300368945 TRAVEL VFX | Person 1 | 0:16 |
| Travel VFX - 24.05.2019 | Person 1 | 0:16 |
| FW: VFX Payments | Person 1 | 0:16 |
| AD-1007 - Duplicates found in Presentation Tables - CM Failure | Person 2 | 0:27 |
| IDOC 1331836 & 1331791 in Error | Person 2 | 0:15 |
| TVL VFX - 400162026 - Peter Marks | Person 2 | 0:16 |
| Travel VFX | Person 2 | 1:03 |
Hi Alex
I have no problem creating a Pivot Table from your data or even summing the time.
Person 1 is 1:22 (hh:mm)
Person 2 is 2:01
Total 3:23
Just change the COUNT to SUM in the Pivot Table and change the number format to hh:mm.
If it is not working, then please attach your file with some sample data and the Pivot Table that you have created.
Hope this helps.
Sunny
Do you mean you actually have the formula =TEXT("0:16","[h]:mm") in the cell? If so, why? It's pointless as it just returns the text already passed as the first argument.
