Hi there
I have a set of durations from a timesheet app that have durations in hh:mm:ss format. I was trying to pivot those durations but the totals are not showing correctly. For example. I have this data which, when using sum, comes to 638:17:26:
When summed in a pivot table, it comes to 04:34:57.
Any ideas?
Thanks
I have a set of durations from a timesheet app that have durations in hh:mm:ss format. I was trying to pivot those durations but the totals are not showing correctly. For example. I have this data which, when using sum, comes to 638:17:26:
Project A | 14:03:57 |
Project A | 14:19:49 |
Project A | 17:49:00 |
Project A | 17:56:00 |
Project A | 15:44:07 |
Project A | 15:57:31 |
Project A | 16:14:03 |
Project A | 11:31:08 |
Project A | 13:57:37 |
Project A | 15:25:00 |
Project A | 18:34:45 |
Project A | 18:39:19 |
Project A | 09:05:00 |
Project A | 12:50:05 |
Project A | 00:55:00 |
Project A | 13:59:44 |
Project A | 11:41:36 |
Project A | 16:08:27 |
Project A | 11:07:56 |
Project A | 18:49:53 |
Project A | 09:00:00 |
Project A | 09:05:00 |
Project A | 09:20:00 |
Project A | 10:30:00 |
Project A | 15:17:22 |
Project A | 18:39:00 |
Project A | 10:30:00 |
Project A | 15:13:00 |
Project A | 15:20:00 |
Project A | 15:34:00 |
Project A | 15:39:00 |
Project A | 10:30:00 |
Project A | 18:37:00 |
Project A | 11:41:36 |
Project A | 11:07:56 |
Project A | 18:49:53 |
Project A | 10:30:00 |
Project A | 18:39:00 |
Project A | 10:30:00 |
Project A | 10:30:00 |
Project A | 18:37:00 |
Project A | 11:07:56 |
Project A | 18:49:53 |
Project A | 10:30:00 |
Project A | 18:49:53 |
Project A | 10:30:00 |
When summed in a pivot table, it comes to 04:34:57.
Any ideas?
Thanks