|
|
#11
11-04-2018, 07:20 PM
|
||||
|
||||
I would like that the hours of work only display a figure if there is a start and end time preceding that column. - Remove the zeroes by <File-Options-Advanced>Scroll down until you find 'Display Options for this Worksheet' then uncheck 'show a zero in cells that have zero value'. Although this could also be done with a formula or conditional formatting Something is wrong though, I have credits when tasks not even performed yet, so if I add them all up and deduct from grand total it makes it look extremely healthy !!!Can you fix that for me ? - I added another IF in the formula under credit and debit columns to return zero (not blank) if there is no data to compute. copy the formula down to the next set of tasks. I wanted it that the credits and debits are then introduced into the grand total to show me the new expected total time it all takes, as I progress. - Grand Totals of estimated hours plus grand totals of credit hours minus grand totals of debit hours or =d45+y45-z45 I suggest you feed your data in a Ghantt Chart to get a better picture of the progress of your on going project. 
|
|
|
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 32bit 
Office 2007
Threaded Mode