|
|
#2
09-04-2011, 11:10 PM
|
|||
|
|||
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 
|
|
|
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 |
Windows Vista 
Office 2007
Threaded Mode