View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Dyson Dyson is offline
external usenet poster
 
Posts: 1
Default 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?