pieces picked per hour

Discussion in 'Excel Beginners' started by curseddiamond, Jan 16, 2014.

  1. 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
     
    curseddiamond, Jan 16, 2014
    #1
    1. 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 (here). After that, you can post your question and our members will help you out.