- Charts
- Formula
- Printing
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