Calculating Hourly Productivity

  • Thread starter Thread starter Scott
  • Start date Start date
S

Scott

How can I work out the hourly productivity e.g. the
number of pieces of work processed within a given time.

If a member of staff works 06:30:00 hours on shift and
process 130 pieces of work the hourly productivty would
be 20/hour. How can I write a formula to calculate this?
 
Scott,

Un its in A1, hours in B1

productivity
=A1/(B1*24)

This is because time is stored as a fraction of 1 day, so you multiply by 24
to get the decimal hours.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Scott
Assuming piece count in A1 and time in A2 then

=A1/(A2*24

Excel stores time in decimal portions of a day so you need to multiply the time by 24 to get it into hours

Good Luck
Mark Graesse
(e-mail address removed)

----- Scott wrote: ----

How can I work out the hourly productivity e.g. the
number of pieces of work processed within a given time

If a member of staff works 06:30:00 hours on shift and
process 130 pieces of work the hourly productivty would
be 20/hour. How can I write a formula to calculate this
 
Back
Top