Excel Calendar for 5x8 Schedule

Solved
lgjean -  
wzanas Posted messages 2 Status Membre -
Hello, does anyone have an Excel sheet (a template?) to create a perpetual schedule for a 5x8 work shift?
The shifts are 2 days from 5am to 1pm, 2 days from 1pm to 9pm, 2 days from 9pm to 5am, and 4 days off.
The whole schedule is organized for 5 teams continuously, with no public holidays.

Thank you for your ideas!

Jean

12 réponses

lgjean
 
No, it's officially 5x8, as this designation refers to the number of teams rather than the hours. Here, it's 5 teams of 8 hours.

Jean
35
doume
 
I have a perpetual calendar; what I lack is how to establish the payroll.
0