Forum Discussion
kevs44
Apr 07, 2026Copper Contributor
How total up hours?
Ive tried to total up hours with autosum, but not work. Thanks Mac
1 Reply
- Riny_van_EekelenPlatinum Contributor
Provided that these are real time values, you can enter a formula =SUM(C2:C16) where you want the total to be.
Then apply a custom format to that cell like [hh]:mm. That will tell Excel it's dealing with a duration, not a clock time. Leaving the cell in its default format will wrap after every 24 hours and display the remainder as clock time.
Example attached.