Produtivity Formula

T

Tom Slypaw

Hi,

I have searched the forums but could not find the answer to this:

Right now I calculate productivity as such:

=IF(Q3=0,0,(Q3/M3)*8)

Q3 is units completed
M3 is hours worked

Multiplyling by an 8 hour shift gives me the productivity.

Instead of calculating at the end of the workshift, I am looking for
way to have a running total.

I have a worksheet running total individual completions (shared) as th
employees enter data.

Is there a formula I can add that would calculate if an employee begin
his shift at 7:am and has 3 completion at 9:am, and calculate th
productivity?

Thank you,

~To
 
G

Gary's Student

Your formula is correct as is. Given the number of units completed in a
couple of hours it calculates the productivity in a full 8 hour working day
(nobreaks, no lunch).


If you put the starting time in A1 and the finish time in B1, then use the
formula =24*(B1-A1) to get the hours worked. Put this formula in M3 and your
IF formula should work.
 
C

CLR

Assuming that is the shift starts at 7am and the employee has 3 units done
at 9am ..........you want to know if he's "on track" or not.........if so,
you can use a standard "units per hour" figure based on historical data and
compare his current "quantity complete" and "hours worked" to that
standard..............

Vaya co Dios,
Chuck, CABGx3
 
Top