Adding Time Values


When using a standard SUM formula to add the time values in column B (=SUM(B2:B5)), a false result of 4:23 is returned, rather than the actual sum of 28:23.


Excel's default time format does not allow a time value to exceed 24 hours. This is the cause of the above error.
To properly display a sum exceeding 24 hours, change the format of the cell from "h:mm" to "[hh]:mm".


  1. Thanks. What if my total hours value exceeds 10000hours e.g.
    12345:25+3:45... to display 12349:10
    Excel is not displaying values higher than 10000:00 hrs.

    Please assist

Leave a Reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.