How to create duty roster in excel. (24×7 rotational shift )

[@ranjanchoudhary]

Nice sir

[@ramkrishnabarnwal7772]

❤❤❤❤❤

[@dianacastillo7097]

Hi, great tutorial. But can you show too, how to compute for total number of work hours per employee using the legend you use, say for example A is 12hrs, etc. thank u

[@sanditechnology]

Thanks, Yes you can show that total work hours per employee by using a formula such as
Total present day multiple by one day work hours.

[@jitendrasolanki4678]

I have changed month then not change weakly of as per previous month January and also not change shift

[@sanditechnology]

If you change the the month only format will be changed not weekly of or shift.
If you want to change weekly of shift , at first you have to save the format as a template than enter your data as you want.

[@deccanriders4997]

What if the month cycle is between two different months?

[@indianindia7034]

Timing kya hai...how shift change.??..incomplete

[@anilsurwase5186]

1st weekly off type karke agle off auto matic kaise ate hai

[@sagarbadhe1928]

सेम Diuty rosters 8 hour and 6 hour af inculcated night shift 12 hour format 15 workers

[@choudhrycommunication4200]

I have 24 hr every employee get 4 w/o in month if month is 30 day every employee perform duty 26 days plz manage day off every employee

[@sanjayragavendra6678]

Dollar wala lock nai lag raha hai

[@sanditechnology]

Please try again with carefully

[@nileshgoswami5051]

6day hone par automatic off kase lagaye

[@sanditechnology]

You have to apply same formula and condition.