MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How do I sum time values?


Posted by David Price on July 07, 2001 12:13 PM

I have a number of formulas that calculate the difference between two times of the day. The cells are formatted to produce the result in hours and minutes.
When I put a sum formula at the end of the row to add these times it will add the first two and then it seems to revert to a smaller number. I think that it is adding the time value not the actual hours and minutes.
Thank you in advance for your help
David P.

Posted by Aladin Akyurek on July 07, 2001 12:23 PM

You need to custom format the cell where you sum times values as

[h]:mm

Aladin