Good morning, He is my next issue:

I have a field satrt time and a field end time. These are date and time fields.

What i need is to find out how much time in days, hours, minutes, and seconds have passed between the two dates. When i try to do it:
End-Start I get the answer i need with the cell formated d:h:mm:ss
However when I add them all up when it gets to thirty days it switches over to 0. An example

Elapsed Time (D:H:MM:SS):

6:10:10:10 (+)
6:20:10:10 (=12:30:20:20 +)
12:20:10:10 (= 00:50:30:30)

I hope that is clear, the numbers on the left are the elapsed times.
Is their a way i can make it not roll over? The ultimate goal is to find the average of the three entries. I am currently using a pivot table to do the average function and it is messed up too. However one issue at a time.

Thanks for the help.

Scott

There is not a direct way of doing this via formatting. You can use a worksheet function to return the format that you want.

For example...

If the range that you want to sum is in A1:A50 then this should do the trick. Note that you can't do time calculations with the result of this formula.

=INT(SUM(A1:A50))&TEXT(SUM(A1:A50),":hh:m:ss")

Actually it rolls over at 31 days as the cumulative date goes from January 31, 1900 to February 1, 1900. Internally the numbers are OK and you can use them for calculations. So you can use them for "go." Use Eric's trick for "show."

If you want you can use the following format [h]:mm:ss which will give you total hours e.g 754:13:42.