| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
pieces picked per hour
I am trying to calculate the pieces my employees are picking in a hour. the system we use will not calculate it and I have to do this 1 pick ticket at a time.
the data I have available is the time they started/ended a pick ticket in hour and minute of day format 6:03/6:33 and the number of pieces that they pick (61) which would turn into 122 pieces in an hour as the picked 61 pieces in 30 minutes. how do I make a formula that will do the calculating for me and how should I format the cells? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting from 12-hour to 24-hour format | Excel Worksheet Functions | |||
| Range is not being picked up | Excel Programming | |||
| convert decimal numbers to a fraction of an hour for payroll hour | Excel Worksheet Functions | |||
| How can I round an hour to the nearest 1/4 hour? | Excel Worksheet Functions | |||
| Just a tip I have picked-up | Excel Programming | |||
Hybrid Mode
