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" <[email protected]> wrote in message
news:[email protected]...
> 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
>

[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)


"kevcar40" <[email protected]> wrote in message
news:[email protected]...
> Bob
> this tells me if i am on target or not
> however is there a way of show what percentage efficeint i am ?
>