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?

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.
Similar Threads
  1. roandr

    Hour's pay calculations

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

    £20 per hour

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

    calculation of pounds per hour

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

    patients per hour

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

    Formula to calucalte part per hour?

    LaQaunda, May 6, 2008, in forum: Excel Beginners
    Replies:
    5
    Views:
    106
    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:
    173
    ShaneDevenshire
    Sep 20, 2008
  7. Mike Stewart

    multiply # of pieces

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