How to add hours together

		Microsoft Office Forums > Microsoft Excel > Excel
How to add hours together

FAQ

Thread Tools

Display Modes

09-03-2011, 08:26 PM

PomDave

Windows Vista How to add hours together

Office 2010 32bit

Advanced Beginner

Join Date: Sep 2011

Location: Australia

Posts: 49

How to add hours together

Hi All,

My next question relates to adding times together. If I add 3 cells each with 7 hrs 40 mins in each I get an answer of 23 - correct.

Add 4 cells together I get 6:40, whch if I interpolate, is 24 hours + 6 hrs 40 mins also correct.

BUT

if I want to add say 20 cells together the calculation gets worse. Is there a way of getting the correct hours/minutes from Excel?

Rgds,
Dave R

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Actual working hours per day	climbatron	Project	2	12-17-2015 03:13 PM
Help with 'hours worked' calculation...	Snvlsfoal	Excel	1	08-11-2011 05:54 AM
Converting decimal to hours	jhwtsang	Excel	4	05-16-2011 01:36 PM
Cell with hours	meninio	Excel	3	02-11-2011 06:50 AM
Help on the formulate hours	meninio	Excel	2	02-11-2011 04:56 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:54 PM.