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 a
way to have a running total.

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

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

Thank you,

~Tom


--
Tom Slypaw
------------------------------------------------------------------------
Tom Slypaw's Profile: http://www.excelforum.com/member.php...o&userid=18739
View this thread: http://www.excelforum.com/showthread...hreadid=376444

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.
--
Gary's Student


"Tom Slypaw" wrote:


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 a
way to have a running total.

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

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

Thank you,

~Tom


--
Tom Slypaw
------------------------------------------------------------------------
Tom Slypaw's Profile: http://www.excelforum.com/member.php...o&userid=18739
View this thread: http://www.excelforum.com/showthread...hreadid=376444

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


"Tom Slypaw" wrote
in message ...

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 a
way to have a running total.

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

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

Thank you,

~Tom


--
Tom Slypaw
------------------------------------------------------------------------
Tom Slypaw's Profile:
http://www.excelforum.com/member.php...o&userid=18739
View this thread: http://www.excelforum.com/showthread...hreadid=376444