View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
tele2002 via OfficeKB.com
 
Posts: n/a
Default Calculating elapsed time

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