• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

excel formula

Daks

New Member
want to prepare shift schedule for team.
1.The shift should be in rotation A-C-B.
2.The weekdays marked RED are Ot days.
3.All the member should get same Ot days in month
4.There should be 2 member per shift every day
5. 1 OFF for each member in week.
 

Attachments

  • Book1.xlsx
    15 KB · Views: 7
Each day 1 person should be in each shift (1 person in A shift, 1 person in C shift,1 person in B shift,) in rotation for 1st 8 employe. 6 days continue work in single shift then off and then shift change
 
Back
Top