Im creating a worksheet for a 12-hr shift team rotation schedule. Each team has a schedule of W,R,O,O,D,D,N,N and back to W.
W=Work Rest
R=Rest
O=Off
D=Day Shift
N=Night Shift
The pattern always repeats itself every 8 days
What I wish to create is to have a date that always increase by 1 day automatically together with the shift pattern
There are a total of 4 teams and their schedule is as follows.
Team1
From 1Sep09 onwards =>N,N,W,R,O,O,D,D
Team2
From 1Sep09 onwards =>D,D,N,N,W,R,O,O
Team 3
From 1Sep09 onwards =>O,O,D,D,N,N,W,R
Team 4
From 1Sep09 onwards =>W,R,O,O,D,D,N,N
Bookmarks