Previously I got help for the 4x4 rotation schedule based on 8 hours=1day.
Now I'm seeking help again, Please help in this problem also.
I've a requirement to modify 4x4 rotating schedule using a String-based pattern to define the rotation. String pattern (DDDDXXXNNNXDDDXXXNNNXXXXXXX) X=skip days/off days, D/N = Schedule days/work days.
In this case 12 hours = 1 day.
I'm trying to figure out how this rotation can be handled with formula. 4 days work then skip 3 off days then 3 workday then skip 1 off day then 3 work day again skip 3 days then 3 days work and then skip a whole week. and this pattern goes on.
I've attached the workbook to show the sample data and expected outcome.
Bookmarks