|
|
|
|
#1
11-05-2018, 12:27 PM
|
|||
|
|||
Hi Marcia,
many many thanks, I have filled in task 5 but the net credit debit then goes ######## How do I get the cell for days @ 11hrs a day work to display days, I try for grand total after creditdebit/11 but cannot display a day figure. Not aware of a Ghantt chart, sounds useful so when time allows I will explore, no time at the mo, as this excel chart is telling me, I am in need of a day I dont have :-( DBenz 
|
|
#2
11-05-2018, 02:53 PM
|
||||
|
||||
|
The net credit hours display ############# because the net result from task 1 to 5 is negative, meaning the workers clocked in more hours on the tasks than the total allowed hours of work.
To get the 11 hour days, you multiply your initial formula by 24, the total hours in a day.
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Adding Hours in MS Project with Picture | Hochbau | Project | 6 | 02-17-2017 09:45 AM |
| Calculate Time in Hours and Percent | pabyford | Excel | 6 | 12-13-2016 12:29 PM |
| Time Function for Tracking Hours | Newto365 | OneNote | 0 | 07-11-2016 09:47 AM |
 8 in 24 hours time formula
|
v1rt8v2 | Excel | 7 | 01-12-2016 06:55 PM |
|
Adding of times total to be in hours
|
jen0dorf | Excel | 4 | 06-20-2014 11:53 PM |
Windows 7 64bit 
Office 2010 32bit
Hybrid Mode