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.
- Choose Custom tab
- 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