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
     
    curseddiamond, Jan 16, 2014
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. roandr

    Hour's pay calculations

    roandr, Feb 13, 2004, in forum: Excel Beginners
    Replies:
    12
    Views:
    151
    Ken Wright
    Feb 17, 2004
  2. Daran

    £20 per hour

    Daran, Jun 6, 2004, in forum: Excel Beginners
    Replies:
    3
    Views:
    107
    Daran
    Jun 6, 2004
  3. george

    calculation of pounds per hour

    george, Aug 2, 2005, in forum: Excel Beginners
    Replies:
    2
    Views:
    114
    Harald Staff
    Aug 2, 2005
  4. dr350x

    patients per hour

    dr350x, May 6, 2007, in forum: Excel Beginners
    Replies:
    9
    Views:
    122
    dr350x
    May 7, 2007
  5. LaQaunda

    Formula to calucalte part per hour?

    LaQaunda, May 6, 2008, in forum: Excel Beginners
    Replies:
    5
    Views:
    92
    Gord Dibben
    May 7, 2008
  6. kg

    How to use count for calls per hour

    kg, Sep 20, 2008, in forum: Excel Beginners
    Replies:
    1
    Views:
    159
    ShaneDevenshire
    Sep 20, 2008
  7. Mike Stewart

    multiply # of pieces

    Mike Stewart, Mar 7, 2009, in forum: Excel Beginners
    Replies:
    6
    Views:
    121
    Shane Devenshire
    Mar 8, 2009
  8. Juulli
    Replies:
    1
    Views:
    121
    Bernard Liengme
    Apr 30, 2009
Loading...