Weekly employee shift schedule template (Excel)
A ready weekly roster in Excel: pick a shift for each employee each day from a list (morning, evening, night, rest day, leave), and the sheet counts each employee's shifts and weekly hours and how many staff are on shift each day. Free, no signup.
Building the rota every week?
In Dawmly you set up shifts and assign them once, each employee sees their shift on their phone, and lateness is counted against their own shift start. Shift scheduling is on the Starter plan; attendance is free for up to 3 employees, no card needed.
Start freeNext step: Shift scheduling · Attendance app · Overtime sheet
What's in the file
- The weekly roster: 20 employees × 7 days, Saturday to Friday, with a shift-code list in every cell.
- The shifts sheet: each shift's code, name, start and end, with its hours worked out. Change them to fit your company.
- Automatic sums: shifts and weekly hours per employee, and staff on shift each day.
How to use the shift schedule
- On the "Shifts" sheet, set the start and end of the morning, evening and night shifts.
- On the roster, enter the first day of the week and the employee names.
- Pick a code for each employee and day: M morning, E evening, N night, R rest day, L leave.
- Check each employee's weekly hours and the staff-on-shift row to make sure every day is covered.
Working hours and the rest day
Egypt's Labor Law No. 14 of 2025 sets normal working hours at 8 a day and 48 a week (Article 117), with at least one weekly rest day. That is why the roster shows each employee's weekly hours: anything above 48 is overtime, paid at a higher rate.
To work out overtime pay, use the overtime sheet or the overtime calculator.