find efficeincy

[kevcar40]

Hi i need to find the efficeiny of a project
i have 60 minutes availalble
i have a target of 78
if i have no stoppages and produce 78 i am 100%
if i have 30 mins stoppages and produce 39 i am 100%
if i have no stoppages and produce 39 i am 50%
can anyone tell me an easy wy of calculating this

thanks
kevin

 

[Bob Phillips]

=IF(num_produced>=target*(mins_available-stoppages)/mins_available,"On
target","Off target")

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[kevcar40]

thank you

 

[kevcar40]

Bob
this tells me if i am on target or not
however is there a way of show what percentage efficeint i am ?

 

[Bob Phillips]

Hi Kev,

Sure, just use

=(target*(mins_available-stoppages)/mins_available)/target

and format as percentage


--

HTH

RP
(remove nothere from the email address if mailing direct)