pieces picked per hour


C

curseddiamond

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 pic
ticket at a time.

the data I have available is

the time they started/ended a pick ticket in hour and minute of da
format 6:03/6:33 and the number of pieces that they pick (61) whic
would turn into 122 pieces in an hour as the picked 61 pieces in 3
minutes.

how do I make a formula that will do the calculating for me and ho
should I format the cells
 
Ad

Advertisements


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

Top