How do I create a daily shift roster in Excel?

Set up a matrix with hourly time slots down the left and one column per employee. Put the date in cell A1, time intervals across the top row, and staff names down the first column, then fill the cells to show who is working each hour. Our free template comes pre-built with this layout — or follow the step-by-step section above to build one from scratch. For a deeper walkthrough see our guide on how to create a staff roster.

Does Excel have an employee schedule template?

Excel ships with a few generic schedule templates, but they are built for US workweeks and rarely match Australian trading hours, breaks or roles. This free daily shift roster is purpose-built for hour-by-hour planning and works in both Excel and Google Sheets. You can also compare free shift schedule template formats to pick the right one.

Can the roster calculate hours automatically?

The template includes a simple formula row that totals each person’s scheduled hours for the day. It does not calculate wages, penalties or award entitlements — for automated pay-aware calculations use rostering software instead of a spreadsheet.

Is there a free schedule template I can use without signing up?

Yes — this template downloads instantly with no signup or email required, and you are free to edit it to suit your venue. Browse the rest of our free roster templates if you need a different layout.

What time range does the template cover?

It includes hourly rows from 6am to midnight. You can add earlier or later rows in seconds to match your venue’s actual trading hours.

How do I mark breaks?

Type a clear indicator like ‘BREAK’ or shade the cell a different colour. This makes it obvious when a staff member is unavailable mid-shift so you can avoid coverage gaps. See our guide on scheduling breaks compliantly.

Can I assign staff to different positions during the day?

Yes — note the position in each time slot. For example, an employee might be on counter from 9am–12pm, then move to the kitchen from 12pm–3pm.

When should I use this instead of a weekly roster?

Use the daily roster when you need hour-by-hour planning for a particularly busy day, an event, or a venue with many short shifts. The weekly staff roster template is better for regular ongoing scheduling.

FREE TEMPLATE Last updated 26 June 2026

Free daily shift roster template (Excel)

Hour-by-hour shift planning for businesses that need detailed daily coverage. Perfect for high-turnover venues, busy service days and events where you need to see exactly who's working each hour.

Daily shift roster

Excel format (.xlsx) • Ready to download

Hourly time slots (6am–12am)

Employee columns for easy tracking

Break and position indicators

Notes for special instructions

No signup required. Works with Excel and Google Sheets.

This daily shift roster template is a general planning tool only. It does not calculate wages, penalties, overtime or award entitlements. For pay-aware scheduling and compliance support, use dedicated rostering software and check your obligations with Fair Work. It does not constitute legal, HR, or professional advice and should not be relied on as a substitute for advice specific to your business, workforce, or circumstances.

References HR Hub disclaimer Modern Awards Fair Work

What's in this template

Hour-by-hour coverage planning

Hourly time slots

Rows run from opening to closing (e.g. 6am–12am) so you can see every hour at a glance.

Employee columns

One column per staff member on shift — add or remove columns as your team changes.

Break indicators

Mark meal and rest breaks clearly so coverage gaps are obvious before they happen.

Position / area

Assign staff to stations or zones — counter, kitchen, floor — for each time slot.

Notes column

Capture special instructions, deliveries or handover notes for any part of the day.

Daily hours tally

A formula column totals each person’s scheduled hours so you can sanity-check the day.

How the hourly view works

Time runs down the left column, with each staff member in their own column. Fill cells to show when each person is working. This makes it easy to see coverage at any hour and spot gaps before they cost you a busy service.

Time	Sarah (Manager)	James (Barista)	Emma (Floor)	Notes
7:00 AM	Opening	-	-	Setup
8:00 AM	Counter	Coffee	-	Rush starts
12:00 PM	BREAK	Coffee	Floor	Lunch peak

How to create a daily shift schedule in Excel

Four steps to build one from scratch

1. Set up the layout

Put the date in cell A1 (Format Cells → Long Date), time intervals across row 2 from column B (drag the fill handle), and employee names down column A from A4.

2. Block out each shift

Fill the cells where each person is working. Use a different note for breaks, and assign a station or role in the same cell where it helps.

3. Total the hours

Add a formula at the foot of each column to total scheduled hours — handy for keeping the day within budget before you publish it.

4. Colour-code for clarity

Apply conditional formatting to flag breaks, roles or gaps in cover so the busiest hours stand out instantly.

Prefer to skip the setup? The free template above already has the layout, formulas and colour-coding built in. For more on laying out a reusable grid, read our guide to designing roster templates.

How to use this template

Download and go in four quick steps

Download

Grab the Excel file — no signup, opens in Excel or Google Sheets.

Add your staff

Replace the sample names with one column per employee on shift.

Fill the time slots

Mark who is working each hour, plus breaks and positions.

Share or print

Post it for the team or export to PDF for the noticeboard.

Who uses this template

Ideal for detailed daily planning

Busy service days

Plan tight coverage for peak trading periods

High-turnover venues

Manage multiple shift changes across one day

Events & functions

Coordinate staff hour-by-hour for one-off events

Running a hospitality venue? See our tips on solving common hospitality rostering challenges and our dedicated guide to rostering hospitality staff.

When Excel stops keeping up

Daily rosters in Excel work for the occasional busy day. But once you're updating hourly schedules, juggling breaks and coordinating positions every shift, a spreadsheet gets overwhelming fast. RosterElf's drag-and-drop rostering builds the day for you, factors in availability, and shares it straight to your team's phones.

Start free trial See rostering software

Rostering guides

Plan smarter shifts with these how-to guides

Related templates

Explore more free roster templates

FAQ

Daily shift roster FAQ

Set up a matrix with hourly time slots down the left and one column per employee. Put the date in cell A1, time intervals across the top row, and staff names down the first column, then fill the cells to show who is working each hour. Our free template comes pre-built with this layout — or follow the step-by-step section above to build one from scratch. For a deeper walkthrough see our guide on how to create a staff roster.
Excel ships with a few generic schedule templates, but they are built for US workweeks and rarely match Australian trading hours, breaks or roles. This free daily shift roster is purpose-built for hour-by-hour planning and works in both Excel and Google Sheets. You can also compare free shift schedule template formats to pick the right one.
The template includes a simple formula row that totals each person’s scheduled hours for the day. It does not calculate wages, penalties or award entitlements — for automated pay-aware calculations use rostering software instead of a spreadsheet.
Yes — this template downloads instantly with no signup or email required, and you are free to edit it to suit your venue. Browse the rest of our free roster templates if you need a different layout.

You appear to be visiting from the UK