Thread: adding up hours as numbers doesnt match hours as time format
View Single Post
 
Old 11-03-2018, 10:46 AM
joeu2004 joeu2004 is offline Windows 7 32bit Office 2007
Advanced Beginner
  
Join Date: Aug 2016
Posts: 32
joeu2004 is on a distinguished road
Default
Quote:
Originally Posted by DBenz View Post
using =C2+C3+C4+C5+C6+C7+C8+C9+C10+C11+C12+C13+C14
Better: =SUM(C2:C14)

Quote:
Originally Posted by DBenz View Post
I have totals of 20:15 07:00:00 and 21:00:00 but adding then these together using a+b+c method I get 00:15:00
Use the Custom format [h]:mm:ss or [hh]:mm:ss .

Then it will display 48:15:00, which is the actual value of the sum.
Reply With Quote