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.

1. Activate the cell that contains your total time
2. Choose Format, Cells.
3. In the Format Cells dialog box, click the Number tab.
4. Choose Custom from the Category list
5. 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.