Calculating Hourly Productivity

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

 

[Bob Phillips]

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)

 

[Guest]

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