Summing times that exceed 24 hours in Excel

Home / Excel / Summing times that exceed 24 hours in Excel

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


Leave a Comment