Hi All,
I need to report on times logged for incidents logged on our helpdesk system.
Format from the system is 01:12:00 hh:mm:ss.
When creating the pivot table to see total time spent on all incidents, I am trying to SUM the times together for overall totals. So if Admin1 spent 00:30:00 on incident 1234, and 1:15:00 on incident 2345, the total should read 1:45:00.
However, the result is altogether blank, not even an incorrect result.
Values do pull through. If I move the time value to the Column Fields, they are all displayed individually.
Any ideas as to how to get this right?
Cheers
Ian