Hi
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?