TIME Solution Needed

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.
 
B

Biff

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Set time interval on date/time picker when creating appointment. 1
Countifs with different restrictions 1
Date Time increment with additional condition of skipping weekends 18
Converting a time calculation to a value to do math with 1
Calculating Cost Per Minute 5
Need conditional data from 1 sheet to populate another sheet 3
Conditional Formulas 5
Calculating Time 7

Top