|
|
|
|
#1
09-04-2014, 11:22 AM
|
|||
|
|||
Change the format of the total to [h]:mm:ss. The way you have it, hh:mm:ss, it displays only the fraction part of the day.
Making that format change, the total becomes 539:11:00. With the current format, 11:11:00 is displayed as it lops off 528 hours (22 days). Edit: I defer to the previous answer above. For some reason, I missed it. Last edited by gebobs; 09-05-2014 at 06:49 AM. 
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Project Hours
|
Mav | Project | 4 | 03-07-2014 04:47 PM |
| Converting hh:mm to hours | Sammael | Excel | 2 | 04-17-2012 01:33 PM |
|
How to add hours together
|
PomDave | Excel | 3 | 09-05-2011 04:43 AM |
| 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 7 64bit 
Office 2010 64bit
Hybrid Mode