+ Reply to Thread
Results 1 to 2 of 2

Im looking to set up production standards based on hours worked vs cases picked average

  1. #1
    Registered User
    Join Date
    04-30-2013
    Location
    Coral Springs florida
    MS-Off Ver
    Excel 2003
    Posts
    3

    Im looking to set up production standards based on hours worked vs cases picked average

    Basically I want it to look like this

    If Joe starts at 7PM and works til 3am he has worked 8 hours total. he picked 700 cases in 8 hours with an average of 87.5 cases per hour average.

    Can you help me please

  2. #2
    Valued Forum Contributor
    Join Date
    03-29-2013
    Location
    United Kingdom
    MS-Off Ver
    Office/Excel 2013
    Posts
    1,749

    Re: Im looking to set up production standards based on hours worked vs cases picked averag

    Hourly Average =C1/((B1-A1)*24)

    Where
    A1=start date/time
    B1 = stop date/time
    C1= Total cases
    Elegant Simplicity............. Not Always

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1