Skip to main content
Dawmly

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 free

Next step: Shift scheduling · Attendance app · Overtime sheet

What's in the file

How to use the shift schedule

  1. On the "Shifts" sheet, set the start and end of the morning, evening and night shifts.
  2. On the roster, enter the first day of the week and the employee names.
  3. Pick a code for each employee and day: M morning, E evening, N night, R rest day, L leave.
  4. 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.

Frequently asked questions

Is the shift schedule free?

Yes, completely free with no signup. It works in Excel, Google Sheets and LibreOffice.

Can I change the shift times and codes?

Yes. All shifts live on the "Shifts" sheet: change a start or end and the hours update across the roster. You can rename the codes too.

How are night shift hours worked out?

It takes the gap between start and end even when the shift ends after midnight, so 12 am to 8 am counts as 8 hours.

How many hours a week can an employee work?

Normal hours are 8 a day and 48 a week under Article 117 of Egypt's labor law; anything above that is overtime.

Keep reading