Knowledgebase: Microsoft Excel
When I add up times, the sum "roll's over" when the total reaches 24 hours. How can I display "25:45" rather than "01:45"?
Posted by - NA - on 28 March 2006 05:44 AM
Solution:
Just format the SUM cell as "[h]:mm" or "[h]:mm:ss".
(140 vote(s))
This article was helpful
This article was not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
Help Desk Software by Kayako Fusion