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

=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" wrote in message
oups.com...
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

thank you

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

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)


"kevcar40" wrote in message
oups.com...
Bob
this tells me if i am on target or not
however is there a way of show what percentage efficeint i am ?