Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
calculate a productivity percentage
Hi guys.
I'm looking for some help. I'm trying to calculate the productivity of my team via excel. What I need is to set an average so that if they complete 12 tasks within an hour this is 100% performance. My two columns are Productive time (in minutes) and forms complete. If it falls below 12 an hour I need the percentage to reflect that. Any help? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
calculate a productivity percentage
Hi,
If we assume a data layout of:- Col A= minutes Col B= units produced C1 = 12. The standard units per hour productiion rate the this formula in D1 returns the % of standard production which can be dragged down =(60/(A1/B1)/$C$1)*100 Mike "Dyson" wrote: Hi guys. I'm looking for some help. I'm trying to calculate the productivity of my team via excel. What I need is to set an average so that if they complete 12 tasks within an hour this is 100% performance. My two columns are Productive time (in minutes) and forms complete. If it falls below 12 an hour I need the percentage to reflect that. Any help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate productivity vs. ncreased work load | Excel Discussion (Misc queries) | |||
calculate percentage in pivot | Excel Discussion (Misc queries) | |||
How do I calculate an average by a certain percentage? | Excel Worksheet Functions | |||
calculate percentage | Excel Worksheet Functions | |||
calculate percentage of two cells | Excel Worksheet Functions |