Calculating using time

**zbor** · 11-12-2009, 05:42 AM

I see where I made mistake...

Try look here is this OK for you now:

SAWS.xls

However, I had to change those ugly merged cells

(only monday adjusted)

Also, I get different values.

Pieces per hour can't be hour. It's a number (I got 3387)

Same is for Pieces per second (i just forgot to remove formatting, but format it as number)

**omletto** · 11-12-2009, 05:54 AM

Firstly I agree with the merged cells, that wasn't me

But the frames per person was correct, D6+J6+P6+V6= 3811 Now what I need is for the 3811 to be divided by the total hrs worked less the total justified down time 25hrs 3mins which should come to approx 152.