Results 1 to 2 of 2

Calculate number of people needed based on total hours and number machines avalable

Threaded View

  1. #1
    Forum Contributor
    Join Date
    04-06-2017
    Location
    Wolverhampton
    MS-Off Ver
    Office 365
    Posts
    480

    Calculate number of people needed based on total hours and number machines avalable

    Hello All

    Please see attahed

    I’m trying to work out how many people I need to build a customer order
    I’ve worked out how many hours is required to build a week’s order
    K9 = 94 hours required to build

    AA = number of machines available
    X2 7.5 hour Shifts per day

    K23 = to return number of people needed to build week 8's work
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to work out number of 'days' worked based on total hours
    By tangcla in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-20-2016, 10:12 PM
  2. Calculate cumulative total based on given number in cell
    By channguyen in forum Excel General
    Replies: 5
    Last Post: 10-02-2015, 04:44 AM
  3. Calculate date based on number of hours
    By SuddenImpact in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-25-2015, 08:59 AM
  4. Class Summary Sheet adding number of hours for all people with same last name
    By DebbieDoesData in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-04-2015, 05:12 PM
  5. Excel 2007 : Total number of People on Break?
    By sushil10s in forum Excel General
    Replies: 1
    Last Post: 11-09-2011, 07:06 AM
  6. Replies: 5
    Last Post: 08-06-2009, 05:17 PM
  7. calculate number of people
    By jackass85 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-13-2008, 02:52 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