What should a staff roster template include?

Name, day and date, start time, finish time, unpaid break in minutes, calculated paid hours, role or section, and a notes column. Paid hours should be a formula rather than a typed number, so it cannot fall out of step with the times beside it.

How do I calculate paid hours in a roster spreadsheet?

With start in C2, finish in D2 and the unpaid break in minutes in E2, use =(D2-C2)*24-E2/60. For a shift that crosses midnight, use =(D2-C2+(D2<C2))*24-E2/60. Format the start and finish cells as time and the result as a plain number.

How much notice do I need to give before changing a roster?

It depends on the award or enterprise agreement covering your staff, and it differs between hospitality, retail and clerical work. Check your award on the Fair Work Ombudsman's website rather than relying on a general figure.

Is Excel or Google Sheets better for a roster?

Google Sheets if more than one person edits it or staff need to see it from a phone, because there is only ever one live copy. Excel if you work offline and print the roster. The risk with Sheets is that anyone with the link can edit, so share a view-only copy and keep one editable original.

Rosters7 min read

How to build a staff roster template that actually holds up

Most roster templates are a grid of names and days, and they work right up until someone swaps a shift. This is what to put in the template so that the second week is easier than the first, not harder — and the honest point where a spreadsheet stops being the right tool.

Last updated 6 September 2026

The columns a roster template needs

A roster has one job: every person knows where to be, and you know what it costs before the week starts. Almost every template you can download does the first half and skips the second, which is why the wage bill is always a surprise on Monday.

Seven columns cover it. Anything beyond these is decoration; anything missing from these is a question somebody will have to ring you to ask.

Name — one row per person, not one row per role. Roles change, people do not.
Day and date — both. "Tuesday" alone is ambiguous the moment you file the sheet.
Start and finish — as separate cells, so you can do arithmetic on them.
Unpaid break — the minutes, not a tick. This is what makes paid hours wrong.
Paid hours — finish minus start minus break, calculated, never typed.
Role or section — bar, floor, kitchen. This is how you spot you have four people on the floor and nobody on the pass.
Notes — "finishes early, exam". The column that stops the same conversation twice.

The template, filled in

Copy this straight into a spreadsheet as the first two rows. The header row is the template; the row under it shows what a real entry looks like, including the break in minutes and the calculated hours.

Name	Day	Date	Start	Finish	Break (min)	Paid hours	Section
Sam	Tue	08/09	16:00	22:30	30	6.00	Bar
Priya	Tue	08/09	07:00	15:00	30	7.50	Kitchen
Jordan	Wed	09/09	17:00	01:00	30	7.50	Floor

Calculate paid hours, never type them

The single most common roster error is a typed hours figure that no longer matches the start and finish times next to it. Someone moves a shift, forgets the total, and the roster now disagrees with itself. Nobody notices until payroll.

In a spreadsheet, if start is in C2, finish in D2 and the unpaid break in minutes is in E2, paid hours is:

=(D2-C2)*24-E2/60
Format C2 and D2 as time, and the result as a plain number.
For a shift crossing midnight: =(D2-C2+(D2<C2))*24-E2/60

Put the cost on the roster, before the week starts

A roster that does not show a cost is a guess. Add one column for the hourly rate and one for line cost (paid hours × rate), then total the sheet. Now the roster answers the question you actually care about while you can still change something.

Two honest caveats. Penalty rates, casual loading, overtime and allowances mean the real cost is usually higher than a flat rate suggests — treat this total as a floor, not a payroll figure. And rates are personal information: if the roster gets shared with staff, keep the cost columns on a separate sheet.

Excel, Google Sheets, or paper

All three work. They fail in different ways, and it is worth choosing the failure you can live with rather than discovering it in week three.

	Good at	Fails when
Paper on the wall	Everyone sees it. Nothing to log into. Never goes down.	Someone is not on site. A change means a phone call to each person.
Excel	Formulas, totals, printing. Works offline.	Two people edit it. The version emailed on Friday is not the current one.
Google Sheets	One live copy, shared by link, edits from a phone.	Anyone with the link can edit anything. Accidental deletions are quiet.
A rostering tool	Clash detection, live totals, staff see only their own shifts.	It is another account to manage, and usually another subscription.

The mistakes that cost the most

These are the ones that turn a roster from a plan into a problem. None of them are about the template being pretty.

Publishing before checking availability. One clash means a scramble on the day.
No version marker. Put the week's start date in the filename and in a cell.
Sharing an editable copy with everyone. Share a view, keep one editable original.
Rostering to the roster, not to the trade. Look at last week's actual busy hours.
Forgetting the unpaid break exists. It is the difference between the hours you rostered and the hours you pay.
No record of what changed. When a shift is disputed, the argument is unwinnable without one.

Roster changes, notice and breaks

Minimum shift lengths, break entitlements, and how much notice you must give before changing a published roster are set by the award or agreement that covers your staff — they are not the same across hospitality, retail and clerical work, and they change.

We are not going to print a number here and have you rely on it. Check your award on the Fair Work Ombudsman's site, or use their Pay and Conditions Tool, and write your own rule into the template as a note so the next person rostering does not have to look it up again.

When the spreadsheet stops being the right tool

A spreadsheet is genuinely fine for a handful of people on one site. The point it breaks is not a headcount — it is when the roster starts having a second life in text messages.

If you recognise three or more of these, the template is no longer the thing that needs fixing:

You re-send the sheet every time one shift moves.
Somebody works off a screenshot from Tuesday.
Availability arrives as texts you have to transcribe.
You find a double-booking after publishing, more than once.
Swap requests live in a group chat and get lost.

Or let Smart Roster do it

Smart Roster starts where the slow part actually is: your staff fill in when they can work from a link on their own phone, with no account to make. Then build the week from what they said — copy last week, auto-build from the replies, or drop in the shifts you roster constantly as one-tap presets. You approve and publish; nothing half-built is ever visible to staff.

About Smart Roster See pricing

Questions

What should a staff roster template include?: Name, day and date, start time, finish time, unpaid break in minutes, calculated paid hours, role or section, and a notes column. Paid hours should be a formula rather than a typed number, so it cannot fall out of step with the times beside it.
How do I calculate paid hours in a roster spreadsheet?: With start in C2, finish in D2 and the unpaid break in minutes in E2, use =(D2-C2)*24-E2/60. For a shift that crosses midnight, use =(D2-C2+(D2<C2))*24-E2/60. Format the start and finish cells as time and the result as a plain number.
How much notice do I need to give before changing a roster?: It depends on the award or enterprise agreement covering your staff, and it differs between hospitality, retail and clerical work. Check your award on the Fair Work Ombudsman's website rather than relying on a general figure.
Is Excel or Google Sheets better for a roster?: Google Sheets if more than one person edits it or staff need to see it from a phone, because there is only ever one live copy. Excel if you work offline and print the roster. The risk with Sheets is that anyone with the link can edit, so share a view-only copy and keep one editable original.