Forum Discussion

kevs44's avatar
kevs44
Copper Contributor
Apr 07, 2026

How total up hours?

Ive tried to total up hours with autosum, but not work. Thanks   Mac

 

 

1 Reply

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum 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.