Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Pivot Table - Time

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.

Any ideas as to how to get this right?

Cheers Ian

Pivot Table - Time

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.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