Calculating elapsed time

Hi all, I have reports generated by my servers that displays the elapsed time
of an archive in the format of 00:12:33

This is simply HH:MM:SS

But how do I calculate the total sum?

So if I have the following elapsed times:
01:10:18
01:41:06
02:33:57
04:11:13
04:40:00
05:28:23
07:08:30
07:44:53
08:17:07
10:41:09

and perform an auto sum or manually add the all, I get the result 53:36:36
which is fine.

As soon as I use a pivot table the grand total is 04:26:18 even if I change
the cell format to match the original hh:mm:ss as a custom.

What am I doing wrong?

Many thanks in advance.

Gary

I formatted the total as:
[hh]:mm:ss

And I got:
53:36:36

The [] tells excel to keep counting the hours.

tele2002 wrote:
>
> Hi all, I have reports generated by my servers that displays the elapsed time
> of an archive in the format of 00:12:33
>
> This is simply HH:MM:SS
>
> But how do I calculate the total sum?
>
> So if I have the following elapsed times:
> 01:10:18
> 01:41:06
> 02:33:57
> 04:11:13
> 04:40:00
> 05:28:23
> 07:08:30
> 07:44:53
> 08:17:07
> 10:41:09
>
> and perform an auto sum or manually add the all, I get the result 53:36:36
> which is fine.
>
> As soon as I use a pivot table the grand total is 04:26:18 even if I change
> the cell format to match the original hh:mm:ss as a custom.
>
> What am I doing wrong?
>
> Many thanks in advance.
>
> Gary

--

Dave Peterson

Thanks Dave, I thought it might be simple!

Gary

Dave Peterson wrote:
>I formatted the total as:
>[hh]:mm:ss
>
>And I got:
>53:36:36
>
>The [] tells excel to keep counting the hours.
>
>> Hi all, I have reports generated by my servers that displays the elapsed time
>> of an archive in the format of 00:12:33
>[quoted text clipped - 26 lines]
>>
>> Gary
>

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200512/1