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 you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

Watch MrExcel Video

Forum statistics

Threads
1,099,055
Messages
5,466,310
Members
406,474
Latest member
osama beskales

This Week's Hot Topics

Top