Thread: [Solved] How to add hours together
View Single Post
 
Old 09-04-2011, 11:10 PM
Catalin.B Catalin.B is offline Windows Vista Office 2007
Expert
 
Join Date: May 2011
Location: Iaşi, Romānia
Posts: 386
Catalin.B is on a distinguished road
Default

To add times with a sum that exceeds 24 hours, use a normal sum formula: =SUM(Range)
Then, click Cells on the Format menu, click the Number tab, click Custom in the Category list, and choose the following number format: [h]:mm:ss
Reply With Quote