+ Reply to Thread
Results 1 to 3 of 3

Excel Schedule with Daily Availability and Process Length

  1. #1
    Registered User
    Join Date
    10-06-2011
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    12

    Excel Schedule with Daily Availability and Process Length

    Hi there,

    I need to make a schedule in Excel and I would really appreciate your help. It is best if you check out the attachment - so at the top it has the days of the week (Mon-Fri) and above the day it has how many hours availability there is for workers to work. Down the left hand side it has the different jobs and how many hours it will take to complete the job. At the moment I have filled in the white space the way I want the schedule to work so that it checks how many hours are required for the project and compares that to the availability of that day. However I want to automate this with a formula as my actual schedule has like 150 projects. I am finding it difficult as the formula needs to be aware of the cells above it and aware of cells to the left of it. So I need 1 formula that I can put in that white space which I can copy and paste from cell d4 down to G10. At the moment I can get it going with different formulas in the different cells but it means I can't copy and paste the formula.

    I hope this makes sense. Thank you!
    Attached Files Attached Files

  2. #2
    Forum Contributor Toonies's Avatar
    Join Date
    07-30-2009
    Location
    Newcastle, UK
    MS-Off Ver
    Excel 2016
    Posts
    503

    Re: Excel Schedule with Daily Availability and Process Length

    Hi have a look at this it may help

    http://www.4shared.com/file/92fNx_2E...ine_A__1_.html

    the Login is

    Toonies
    abcd

    and to use the other Userforms abc1

  3. #3
    Registered User
    Join Date
    10-06-2011
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    12

    Re: Excel Schedule with Daily Availability and Process Length

    Hi Toonies,

    Thanks for replying and your efforts, but I was after something a bit more specific for my cause. That is filled with macros, and usernames and passwords etc. What I have attached is a sample of what I really need to do, so I just need to know a good formula that way I can play with it and make it suit for what I really need to do.

    Thanks,

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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