Forum Discussion
How total up hours?
Ive tried to total up hours with autosum, but not work. Thanks Mac
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.
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?
