Pivot tables with hh:mm:ss

Casi

New member
Joined
Oct 10, 2013
Messages
6
Reaction score
0
Points
0
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:


Project A14:03:57
Project A14:19:49
Project A17:49:00
Project A17:56:00
Project A15:44:07
Project A15:57:31
Project A16:14:03
Project A11:31:08
Project A13:57:37
Project A15:25:00
Project A18:34:45
Project A18:39:19
Project A09:05:00
Project A12:50:05
Project A00:55:00
Project A13:59:44
Project A11:41:36
Project A16:08:27
Project A11:07:56
Project A18:49:53
Project A09:00:00
Project A09:05:00
Project A09:20:00
Project A10:30:00
Project A15:17:22
Project A18:39:00
Project A10:30:00
Project A15:13:00
Project A15:20:00
Project A15:34:00
Project A15:39:00
Project A10:30:00
Project A18:37:00
Project A11:41:36
Project A11:07:56
Project A18:49:53
Project A10:30:00
Project A18:39:00
Project A10:30:00
Project A10:30:00
Project A18:37:00
Project A11:07:56
Project A18:49:53
Project A10:30:00
Project A18:49:53
Project A10:30:00

When summed in a pivot table, it comes to 04:34:57.

Any ideas?
Thanks
 

Casi

New member
Joined
Oct 10, 2013
Messages
6
Reaction score
0
Points
0
Oh sorry, the total sum before pivot table comes to 20:51:49. Pivot table still says 04:34:57 though. List of figures I pasted was wrong. Here they are again:
Project A00:17:55
Project A00:13:47
Project A00:09:00
Project A00:07:00
Project A00:06:45
Project A00:12:43
Project A00:09:52
Project A00:15:32
Project A00:21:57
Project A00:10:00
Project A00:18:12
Project A00:05:19
Project A00:05:00
Project A00:15:05
Project A12:10:00
Project A00:12:12
Project A00:17:24
Project A00:36:57
Project A00:19:43
Project A00:13:00
Project A00:05:00
Project A00:05:00
Project A00:15:00
Project A00:07:00
Project A00:02:35
Project A00:03:30
Project A00:14:00
Project A00:10:00
Project A00:06:00
Project A00:12:00
Project A00:05:00
Project A00:14:00
Project A00:03:30
Project A00:17:24
Project A00:19:43
Project A00:13:00
Project A00:07:00
Project A00:03:30
Project A00:14:00
Project A00:14:00
Project A00:03:30
Project A00:19:43
Project A00:13:00
Project A00:07:00
Project A00:13:00
Project A00:07:00
 
Top