Page 1 of 2 1 2 LastLast
Results 1 to 10 of 18

Thread: help creating working schedules

  1. #1
    Seeker andy14's Avatar
    Join Date
    Apr 2019
    Posts
    10
    Articles
    0
    Excel Version
    2016

    help creating working schedules



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello,

    In my work i have to make weekly working schedules for my co-workers.

    Almost all of them are part time workers and have a first main job.

    I have 2 or 3 cases that they have a rotating schedule on their first job but it's always the same:

    example

    day 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15....
    schedule A A A B B C C C F F A A A B B....

    A- 08:00-16:00
    B 16:00-24:00
    c- 24:00-08:00
    F- day off


    So i know what the schedule that they will make on the other company, but i just want that to fill automaticaly on my own schedule when i insert the day of the month.


    Can anyone help me with this tricky formula?

    Thanks in advance

  2. #2
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,183
    Articles
    0
    Excel Version
    Office 365 Subscription
    CROSS POST

    This question has been posted in at least one other forum.
    Do not post any further responses in this thread until a link has been provided to these cross posts.

    Whilst we would rather you didn't cross-post, we know that there may be a valid reason for doing so. All we ask is that you provide the links in your original post to your question in the other forum(s). Read this to understand why: https://www.excelguru.ca/content.php?184

    This forum is full of volunteers that give up their own time to help others, something that should be respected and not taken for granted. It’s never nice for someone to find out that a problem they have spent time solving for you has already been answered somewhere else without them knowing, and so we ask you to make it clear that you have also asked elsewhere.
    Please provide the link(s). If you are unable to do so, tell us where else you have posted this query.
    Ali
    Enthusiastic self-taught user of MS Excel!

  3. #3

  4. #4
    Magician navic's Avatar
    Join Date
    Aug 2013
    Location
    Europe, Croatia
    Posts
    882
    Articles
    0
    Excel Version
    Excel 2013
    If I understood you well, use the VLOOKUP function
    Please see attached file.



    Attached Files Attached Files
    My personal Web Excel Tutorials
    Attention! In the formulas as a delimiter I use a semicolon (; ) if you using my formula, then perhaps you need to use a comma (,)
    Also for a decimal number I use a comma (,) you may need to use point (.) instead of

  5. #5
    Seeker andy14's Avatar
    Join Date
    Apr 2019
    Posts
    10
    Articles
    0
    Excel Version
    2016
    Quote Originally Posted by navic View Post
    If I understood you well, use the VLOOKUP function
    Please see attached file.



    Thanks for the reply Navic.

    The thing is what about day 16 or 2 months from now? I want to know what schedule he does on the other job without having to count days or wasting time.

    what i tought was if he in 01/05/2019 is doing the A schedule, on the day_x will be =day_x - 01/05/2019 and that number will correspond to a posicion on his other schedule (A,B,C...).

  6. #6
    Magician navic's Avatar
    Join Date
    Aug 2013
    Location
    Europe, Croatia
    Posts
    882
    Articles
    0
    Excel Version
    Excel 2013
    Please attach your workbook
    1st sheet set your example situation
    2nd sheet same situation with expected result
    My personal Web Excel Tutorials
    Attention! In the formulas as a delimiter I use a semicolon (; ) if you using my formula, then perhaps you need to use a comma (,)
    Also for a decimal number I use a comma (,) you may need to use point (.) instead of

  7. #7
    Seeker andy14's Avatar
    Join Date
    Apr 2019
    Posts
    10
    Articles
    0
    Excel Version
    2016
    Sorry for the late response it has been a little bit busy around here.

    What i put on that excel was the type of working schedules that i do and the types of schedules my co-workers got on their other job.

    What i need is a formula that returns the schedule that they make on the other job only having me to input the dates that i want to know.

    Thanks for all
    Attached Files Attached Files

  8. #8
    Magician navic's Avatar
    Join Date
    Aug 2013
    Location
    Europe, Croatia
    Posts
    882
    Articles
    0
    Excel Version
    Excel 2013
    I'm sorry but I do not understand you. (Keep in mind that English is not my mother tongue). Read my previous post one more time. I asked you to list some examples of expected results. In which cell you want the formula.
    What's in there is confusing for me. Date 3.5.2019 does not exist in the table above.
    You should have set more examples of expected results.
    My personal Web Excel Tutorials
    Attention! In the formulas as a delimiter I use a semicolon (; ) if you using my formula, then perhaps you need to use a comma (,)
    Also for a decimal number I use a comma (,) you may need to use point (.) instead of

  9. #9
    Seeker andy14's Avatar
    Join Date
    Apr 2019
    Posts
    10
    Articles
    0
    Excel Version
    2016
    Probably it's my English, it's not my mother language too.

    The date 3/05/2019 it's on purpose, the data that we know is:

    -on that day the schedule of subject 2 in the other company is A, so in the day 6/05/2019 should be B

    -Subject 3 on the 03/05/2019 is F and on the day 6/05/2019 should be M


    But i want excel to calculate this automatically without me to have to count days.

  10. #10
    Magician navic's Avatar
    Join Date
    Aug 2013
    Location
    Europe, Croatia
    Posts
    882
    Articles
    0
    Excel Version
    Excel 2013
    Quote Originally Posted by andy14 View Post
    The date 3/05/2019 it's on purpose, the data that we know is:
    ........... so in the day 6/05/2019 should be B....
    1. Why exactly 3.5.2019 date?
    2. You mention the 6.5.2019 date, what does the logic of that date, has to 3.5.2019?
    3. What about other dates, 7.mai, 8.mai, 9.mai etc, do you make shifts for these dates manually?
    4. The difference between the two dates is 3 days, why exactly three days?
    5. What is the logic of the shift schedule?
    6. Does it seem to me that there should be a formula and fixed data in the range? Is there in a range of cells fixed data that you are putting the manually or all cells should contain a formula?
    7. Does this mean, if a subject is free at a certain Date (ie 'F'), you give him a job at a certain time.

    I do not even know what I would ask you because I do not understand your logic?
    Note: Excel formula requires logic and arguments.
    Look at my attachment and enter the expected results manually.
    Attached Files Attached Files
    My personal Web Excel Tutorials
    Attention! In the formulas as a delimiter I use a semicolon (; ) if you using my formula, then perhaps you need to use a comma (,)
    Also for a decimal number I use a comma (,) you may need to use point (.) instead of

Page 1 of 2 1 2 LastLast

Posting Permissions

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