Results 1 to 3 of 3

Thread: Pivot tables with hh:mm:ss

  1. #1

    Pivot tables with hh:mm:ss



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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

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

  3. #3
    Resolved myself.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •