Shift rotation

Hi All,

I'm new to this so please be gentle.

I have been looking at a way to record my shifts which rotate and repeat like so throughout the year, week 1(M-off,T-off,W-On,T-On,F-Off,S-Off,S-Off) Week Two (M-On,T-On,W=off,T-off,F-On,S-On,S-On). I have managed to create a excel sheet that has the dates for every month and what I want to do is have the work sheet enter and repeat this shift pattern with an option to add any overtime shifts that are worked. In addition I want it to total every months working hours. I'm stuck on the formula



Anyone help with this.