Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
efficieny
Hi
i am trying to calcualte the efficieny of a team a1 = mins_available ( 60) b1 = target (100) c1 = stoppages (in minutes) d1 = achieved (ie 50) i have this formula (target*(mins_available-stoppages)/mins_available)/target problem is this does not take into account the quantity achieved against the target what i am trying to do is find out how long they actually worked take what they actually achieved and work out how efficient they were in the available time against the target can anyone help please kevin |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
efficieny
=achieved/(target*(mins_available-stoppages)/mins_available)
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "kevcar40" wrote in message oups.com... Hi i am trying to calcualte the efficieny of a team a1 = mins_available ( 60) b1 = target (100) c1 = stoppages (in minutes) d1 = achieved (ie 50) i have this formula (target*(mins_available-stoppages)/mins_available)/target problem is this does not take into account the quantity achieved against the target what i am trying to do is find out how long they actually worked take what they actually achieved and work out how efficient they were in the available time against the target can anyone help please kevin |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
efficieny
Thank you Bob
|