Problem:
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.
Solution:
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".
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.
Hi Philip,
Yes, Excel does not display values higher than 10000:00 Hrs.
Imran.
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
Awesome! Thanks for posting.