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