Pivot tables with hh:mm:ss

[Casi]

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

[Casi]

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 A	00:17:55
Project A	00:13:47
Project A	00:09:00
Project A	00:07:00
Project A	00:06:45
Project A	00:12:43
Project A	00:09:52
Project A	00:15:32
Project A	00:21:57
Project A	00:10:00
Project A	00:18:12
Project A	00:05:19
Project A	00:05:00
Project A	00:15:05
Project A	12:10:00
Project A	00:12:12
Project A	00:17:24
Project A	00:36:57
Project A	00:19:43
Project A	00:13:00
Project A	00:05:00
Project A	00:05:00
Project A	00:15:00
Project A	00:07:00
Project A	00:02:35
Project A	00:03:30
Project A	00:14:00
Project A	00:10:00
Project A	00:06:00
Project A	00:12:00
Project A	00:05:00
Project A	00:14:00
Project A	00:03:30
Project A	00:17:24
Project A	00:19:43
Project A	00:13:00
Project A	00:07:00
Project A	00:03:30
Project A	00:14:00
Project A	00:14:00
Project A	00:03:30
Project A	00:19:43
Project A	00:13:00
Project A	00:07:00
Project A	00:13:00
Project A	00:07:00

[Casi]

Resolved myself.