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