Remember Me?

#1
September 13th 07, 08:30 AM posted to microsoft.public.excel.newusers
 external usenet poster First recorded activity by ExcelBanter: Sep 2007 Posts: 1
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
September 13th 07, 08:46 AM posted to microsoft.public.excel.newusers
 external usenet poster First recorded activity by ExcelBanter: Apr 2007 Posts: 11,501
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?

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post rfIPS Excel Discussion (Misc queries) 0 May 10th 07 07:02 PM dan Excel Discussion (Misc queries) 1 September 22nd 06 04:16 PM cwilson Excel Worksheet Functions 1 September 11th 06 12:33 AM JP Excel Worksheet Functions 6 March 2nd 05 02:34 PM Suzie Excel Worksheet Functions 4 December 3rd 04 05:27 PM

All times are GMT +1. The time now is 10:58 PM.