Summing Times That Exceed 24 Hours
Q. I have a range of time values, but when I try to sum them, the total is never greater than 24 hours.
When you add a range that contains time values, Excel ignores the hours that exceed 24. The solution is to use a custom number format.
- Activate the cell that contains your total time
- Choose Format, Cells.
- In the Format Cells dialog box, click the Number tab.
- Choose Custom from the Category list
- Type [h]:mm into the box labeled Type.
Using brackets around the hour portion of the format string tells Excel to display hours that exceed 24 hours.
Search for Tips
Browse Tips by Category
Needs tips? Here are two books, with nothing but tips:
Contains more than 200 useful tips and tricks for Excel 2007 | Other Excel 2007 books | Amazon link: John Walkenbach's Favorite Excel 2007 Tips & Tricks