How total up hours?

Question

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

riny_van_eekelen · Answer

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.

kevs44 · Answer

Thanks only thingis then Riny ... best to move hours to a blank column on right correct, ones you want, maybe just one week of... keep original columns no formulas?&nbsp;&nbsp;

Forum Discussion

How total up hours?

2 Replies