TIME Solution Needed

  • Thread starter Thread starter Ed Pedro
  • Start date Start date
E

Ed Pedro

I need to determine the production of our order picker using the time it
takes to pull an order and the amount of lines pulled. Example if the picker
pulled 60 itmes in 30 minutes he's averaging 2 units a minute. I have a
"Time In" column and a "Time Out" column.

T.I.A.
 
Ed,

I should have included this in the reply. If you're times
will roll over past midnight, change the formula in C1 to:

=(B1-A1+(A1>B1))*1440

Times rolling over midnight always seem to cause problems!

Biff
 
Back
Top