Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-03-2011, 08:26 PM
PomDave PomDave is offline How to add hours together Windows Vista How to add hours together Office 2010 32bit
Advanced Beginner
How to add hours together
 
Join Date: Sep 2011
Location: Australia
Posts: 43
PomDave is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 09-04-2011, 11:10 PM
Catalin.B Catalin.B is offline How to add hours together Windows Vista How to add hours together Office 2007
Expert
 
Join Date: May 2011
Location: Iaşi, Romānia
Posts: 386
Catalin.B is on a distinguished road
Default

To add times with a sum that exceeds 24 hours, use a normal sum formula: =SUM(Range)
Then, click Cells on the Format menu, click the Number tab, click Custom in the Category list, and choose the following number format: [h]:mm:ss
Reply With Quote
  #3  
Old 09-04-2011, 11:17 PM
Catalin.B Catalin.B is offline How to add hours together Windows Vista How to add hours together Office 2007
Expert
 
Join Date: May 2011
Location: Iaşi, Romānia
Posts: 386
Catalin.B is on a distinguished road
Default

This format works correctly with times that exceed 24 hours.

Note Range is either the defined name of a range that contains the times or the cell reference of the range that contains your times (for example, A1:A4). The values in the range must be in the "h:mm" or "hh:mm" format.
Reply With Quote
  #4  
Old 09-05-2011, 04:43 AM
PomDave PomDave is offline How to add hours together Windows Vista How to add hours together Office 2010 32bit
Advanced Beginner
How to add hours together
 
Join Date: Sep 2011
Location: Australia
Posts: 43
PomDave is on a distinguished road
Default

Hi Catalin.B

Huh, I see it now. I was using h:mm & h:mm:ss and was getting nowhere.

Thanks for that.

Best Rgds,
Dave R.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Actual working hours per day climbatron Project 2 12-17-2015 03:13 PM
How to add hours together Help with 'hours worked' calculation... Snvlsfoal Excel 1 08-11-2011 05:54 AM
How to add hours together 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 04:29 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft