adding up hours as numbers doesnt match hours as time format

		Microsoft Office Forums > Microsoft Excel > Excel
adding up hours as numbers doesnt match hours as time format

11-03-2018, 10:46 AM

joeu2004

Windows 7 32bit adding up hours as numbers doesnt match hours as time format

Office 2007

Advanced Beginner

Join Date: Aug 2016

Posts: 32

Quote:

Originally Posted by DBenz

using =C2+C3+C4+C5+C6+C7+C8+C9+C10+C11+C12+C13+C14

Better: =SUM(C2:C14)

Quote:

Originally Posted by DBenz

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Adding Hours in MS Project with Picture	Hochbau	Project	6	02-17-2017 09:45 AM
Calculate Time in Hours and Percent	pabyford	Excel	6	12-13-2016 12:29 PM
Time Function for Tracking Hours	Newto365	OneNote	0	07-11-2016 09:47 AM
8 in 24 hours time formula	v1rt8v2	Excel	7	01-12-2016 06:55 PM
Adding of times total to be in hours	jen0dorf	Excel	4	06-20-2014 11:53 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:29 AM.