+ Reply to Thread
Results 1 to 6 of 6

Units installed per hours?

  1. #1
    Registered User
    Join Date
    07-01-2009
    Location
    Indianapolis
    MS-Off Ver
    Excel 2007
    Posts
    5

    Units installed per hours?

    This seem really simple but for some reason my numbers don’t add up. I'm trying to figure out how many access points where installed in amount of hours.
    An employee installed 1547 access points in 2462 hours. I'm trying to figure out how many APs where installed per hour (over 16 months).
    The formula I used in excel was

    1547 / (2462 * 24) = 0.026

    This doesn’t seem right, am I correct?
    Thanks,

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Units installed per hours?

    It's just 1547/2462
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    07-01-2009
    Location
    Indianapolis
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Units installed per hours?

    I get .6283, I was looking for a solid number instead of a percentage.

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Units installed per hours?

    What's a "solid number?"

  5. #5
    Registered User
    Join Date
    07-01-2009
    Location
    Indianapolis
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Units installed per hours?

    A whole number I mean.

  6. #6
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Units installed per hours?

    But it isn't a whole number. (S)he can do one about every 1.6 hours.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Counting total number of units installed
    By frankday in forum Excel General
    Replies: 5
    Last Post: 03-22-2018, 06:53 PM
  2. Convert units and units of measure
    By AntiPivotTable in forum Excel General
    Replies: 1
    Last Post: 10-21-2016, 07:22 PM
  3. [SOLVED] Formula to determine number of units at each location and status of units
    By Klimer in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 08-18-2016, 10:01 AM
  4. Trying to do conditional counting, units within units
    By Butcher1 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-17-2016, 01:01 PM
  5. Distributing remaing units over equal number of hours
    By Monoatomic in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 09-10-2014, 09:51 AM
  6. [SOLVED] working out productivity using HOURS and units to establish accurate daily result
    By Raanan in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-22-2013, 09:47 PM
  7. [SOLVED] Calculate the Bonus units according to the quantity of the units bought (Help)
    By mo_naf in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-15-2012, 05:51 PM

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