How to work an average/productive time

[jimd1768]

We do a time measurement of staff. They have to be productive for 3:00 per day. We have a report that gives the month average. What I would like to be able to show is how productive they need to be for the remainder of the month each day to hit target. I am not sure how I would work this out

example -

Person 1 - after day 16 they are 2:48 productive
they have 5 days left in the month.

What productive time do they need to achieve each day to get to 3:00

Thank you in advance

[Glenn Kennedy]

Something like this, maybe??

[jimd1768]

Glenn, thank you so much for taking the time to assist. Greatly appreciated

[Glenn Kennedy]

Thanks for the Reputation that you have added. It's much appreciated. If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.