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)

Because you didn't pay attention to my previous explanation. I'm done with you.

Hi,
Joeu2004
I see only 8 hrs as most

I don’t understand, I click C2 and its not saying B2+ 08:00:00

BI manually typed the hh:mm:ss into C to represent hrs for the hours in B
B2 is 8 hrs, you say 8 days.

You lost me I’m afraid.


Marcia, I see I have a column sorting out the 00:15:00 thanks.


so edit that out of my response


Dbenz

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.

Attached Files

Copy of Task time estimator and progress credit debit forum version developed F2.xlsx (26.0 KB, 9 views)

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

Attached Files

Copy of Task time estimator and progress credit debit forum version developed F2.xlsx (21.8 KB, 9 views)

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.