Fortnightly Staff Roster: Excel Template for Small Business

Coordinating shifts across a fortnight gets messy fast. Who's on Monday? Did anyone swap Thursday? What did last week look like?

This is a single Excel workbook that gives you a clean, structured view of your team's shifts across a full two weeks. Enter a start time, enter an end time, and the hours calculate on their own.

What's inside:

• Roster Setup tab: enter each staff member once and every other tab reads from it
• Fortnightly Roster tab: one row per staff member per day, start and end times, hours auto-calculated
• Hours Summary tab: total hours per staff member across the fortnight, with contracted hours and variance

Covers up to 30 staff.

Getting started takes about 15 minutes:

1. Open Roster Setup and enter your team's names, roles, and contracted hours
2. Set your fortnight start date on the Roster tab — dates fill in automatically
3. Enter shift start and end times for each staff member and day
4. Hours calculate as you go

New fortnight? Update the start date and the whole roster resets. Save a copy first if you want to keep a record.

A good fit if:

• You have 5–30 staff
• You're managing shifts across a fortnight and want one central place to track them
• You want something clean and simple you can hand to a manager without explaining it first

Probably not the right fit if:

• You need automated notifications or shift swap approvals
• You want integration with payroll software

Works in Microsoft Excel 2016 and later. Compatible with Excel on Mac. Not designed for Google Sheets.

Instant download. One purchase, use it for as long as you run your business.