View Single Post
Old 09-16-2008, 11:30 AM   #2
dplax
Jack Burton
 

Join Date: July 19, 2003
Location: an expat living in France
Age: 38
Posts: 5,577
Default Re: Excel Help please.

The HH:MM format only gives you the rest over from whole days, so if the result would be 25:34 you'd get 01:34.

Try setting the format of your cells to HH:MM:SS (not the first one, towards the end of the list, the example for this format given by Excel is 37:30:55).

Hope that helps!
__________________

dplax is offline   Reply With Quote