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