#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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. |
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 |
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 |