aighot

Weekly Work Schedule Template

Plan a week of shifts for your team. Enter each person's start and end times and unpaid break, and the schedule calculates hours per shift, weekly hours per person, staff on each day, and flags anyone over 40 hours. Print it for the break room or share it as a PDF.

Build the weekly schedule

Enter shifts as 9-17, 9:30-18:00, 7a-3p or 22-6 (overnight). Leave blank or type OFF for days off.

Staff Scheduling Workbook

An Excel rota with automatic hours, four-week rotations, availability and time-off tracking, plus printable weekly and monthly schedules.

Formats: XLSX, PDF, DOCX. Instant download after payment (link valid 72 hours, up to 5 downloads). AI-assisted: the templates were drafted with AI help and reviewed and laid out by Kedop.

$5.00 USD, one-time

Secure card checkout by Stripe. Full refund within 7 days — see the refund policy and license.

How to use the weekly schedule

  1. Choose the week start date and the unpaid break deducted from each shift.
  2. Type each person's name and their shift for each day, such as 9-17, 9:30-18:00, 7a-3p, or 22-6 for an overnight shift. Leave days off blank or write OFF.
  3. Check the hours column. Each shift's length minus the break is added up; anyone above the overtime threshold is flagged in red.
  4. Look at the coverage table below the grid to see how many people and hours are scheduled each day.
  5. Print the schedule for the break room or save it as a PDF to share, or download a CSV for payroll.

Shift times entered in 24-hour format are the least ambiguous. The schedule treats a shift that ends earlier than it starts as running past midnight, so 22-6 counts as 8 hours before the break.

What a good work schedule includes

Calculating hours and overtime

Scheduled hours per shift are the time between start and end minus any unpaid break. Weekly totals help you avoid unplanned overtime: under the US Fair Labor Standards Act, non-exempt employees generally earn time and a half for hours over 40 in a workweek, and some states add daily overtime rules. The schedule flags weekly totals above your chosen threshold so you can rebalance shifts before publishing. Scheduled hours are a plan, not a timesheet; pay should be based on hours actually worked.

Worked example

Jordan works 9-17 Monday to Friday with a 30-minute unpaid break: 7.5 hours a day, 37.5 for the week. Lee works four evening shifts of 15-23 or 16-24, 7.5 hours each after the break, for 30 hours. Priya has five shifts of 7.5 hours, 37.5 hours; Sam five, 37.5 hours. The coverage row shows three people on most weekdays and two at the weekend, which lets a manager see immediately that Sunday lunchtime relies on a single person.

Scheduling tips that reduce no-shows and conflict

Common shift patterns

PatternTypical shiftsUsed in
Standard day9–17 or 8–16, Monday–FridayOffices, clinics
Two-shift7–15 and 15–23Retail, hospitality, light manufacturing
Three-shift / 24-hour7–15, 15–23, 23–7Healthcare, security, logistics
Split shifte.g. 11–14 and 17–21Restaurants
4×10 compressedFour 10-hour daysMaintenance, some offices
12-hour rotationTwo or three 12-hour days, then days offHospitals, plant operations

Printing and sharing

The printed schedule shows names, daily shifts with dates, OFF days and weekly hours in a landscape-friendly table. Post it where everyone can see it, or save a PDF and send it through your team chat. Keep a copy of each published schedule — it is useful for payroll checks and, in places with scheduling laws, as a record of what was published and when.

Handling time-off requests and last-minute changes

Collect time-off requests in one place, with a deadline before each schedule is drafted, so you are not rebuilding the week after it is published. When a change is unavoidable, update the schedule, note the date of the change and tell everyone affected directly rather than relying on them noticing a new printout. For recurring availability — a student who cannot work Tuesday afternoons, for example — keep a short availability list next to the template and check it every time you build a new week.

Frequently asked questions

How do I enter an overnight shift?

Type it as it happens, for example 22-6. A shift that ends earlier than it starts is counted as running past midnight.

Does the schedule deduct lunch breaks?

Yes, the unpaid break you enter is deducted from every working shift.

Can I use 12-hour times?

Yes, such as 7a-3p or 9:30a-6p, but 24-hour times are clearest.

Is the schedule saved?

No. Print it, save it as a PDF or download the CSV before closing the page.

Can it plan more than one week?

It plans one week at a time. The paid workbook covers four-week rotations and a full year of hours.

Why is someone flagged?

Their scheduled weekly hours exceed your overtime threshold (40 by default).

Can I print the schedule without hours?

The printed version includes weekly hours so staff can check them; cover the column or delete it from a CSV copy if you prefer.

Does it handle split shifts?

Enter the day as two separate time blocks in the notes, or add a second row for the same person; the tool counts one shift per cell.