Hi , thanks all,
Marcia, to have this so I can fill it in is great.
yes, if estimated hrs is more than actual its a credit.
Attached is it with your formula now taken down to populate all the task rows.
I would like that the hours of work only display a figure if there is a start and end time preceding that column.
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 ?
In fact those blank rows can be nuked. Original design was sheet 2, they were when I was sussing additions in three chunks.
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.
Is that just a case of grand total -(credit total) +(debit total) cells ?
or will it require different formula ?
I made a task a deliberate credit but the grand total didnt alter.
I still have that wrong 00:15:00 in red fill. so cant use that figure.
DBenz
|