ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   pieces picked per hour (https://www.excelbanter.com/new-users-excel/449695-pieces-picked-per-hour.html)

curseddiamond

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?


All times are GMT +1. The time now is 01:51 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com