Productivity Percentage



I'm trying calculate productivity for my employees in excel. Their schedules can consist of the following different appointments within an 8 hour day.

- 20 minute follow up

- 40 minute consult

- 60 minute procedure

In a full day that can see 24 follow up, 12 consults or 8 procedure (480minute/type of appt)but I want a productivity percentage if there was a mixture of these appointments in a full day how would I put that in a formula in excel for instance if one employee has 1 consult, 12 follow up and 4 procedure what would be his productivity formula?



All of this depends on how you have your data setup in Excel. Edit your quesiton and upload a sample file to get better help.
don (rep: 1297) Feb 3, '17 at 9:01 am
Add to Discussion

Answer the Question

You must create an account to use the forum. Create an Account or Login