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

Attached Files

Task time estimator and progress credit debit forum version developed F2.xlsx (21.2 KB, 11 views)