Creating working schedules

andy14

New Member
Joined
Apr 30, 2019
Messages
1
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?
 
Last edited by a moderator:

Some videos you may like

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

Forum statistics

Threads
1,089,678
Messages
5,409,689
Members
403,276
Latest member
Oscar007

This Week's Hot Topics

Top