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.