ONE LITTLE PROBLEM PROBLEM:[/b]
THE DEFAULT TIME FORMAT DOES NOT ALLOW A TIME VALUE TO EXCEED 24 HOURS.
FOR EXAMPLE, BY ENTERING A TIME OF 28:56:00, THE RESULT IS 04:56:00.

[b]SOLUTION:
Change the format of the cell by placing brackets around the hour,
[HH]:MM:SS. The result is displayed as 28:56:00.


--
Ctrl-T
------------------------------------------------------------------------
Ctrl-T's Profile: http://www.excelforum.com/member.php...o&userid=28192
View this thread: http://www.excelforum.com/showthread...hreadid=477161