Thread: find efficeincy
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default find efficeincy

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 ?