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/showthread.php?9965-help-creating-working-schedules
https://www.excelforum.com/excel-general/1274360-help-creating-working-schedules.html?
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/showthread.php?9965-help-creating-working-schedules
https://www.excelforum.com/excel-general/1274360-help-creating-working-schedules.html?
Last edited by a moderator:
