Results 1 to 1 of 1

Thread: Creating working schedules
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Apr 2019
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Creating working schedules

    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

    EDIT:
    Also posted
    https://www.excelguru.ca/forums/show...king-schedules
    https://www.excelforum.com/excel-gen...chedules.html?
    Last edited by Fluff; Apr 30th, 2019 at 11:26 AM. Reason: Added links

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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