Skip to content
12-Hour Shift Schedule cover: a sample sheet with shifts booked, day shifts and night shifts and a stacked chart, beside the Dashboard, Team and Shifts tabs

12-Hour Shift Schedule

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
5
Difficulty
Beginner
Updated
November 13, 2026

Every slide (5)

Overview

The 12-hour shift schedule is for supervisors of security, control room, care and utility teams who work two crews on day and night rotations. The Team tab lists each person with their crew and the hours limit for the fortnight, then totals booked hours and the spare hours left. The Shifts tab logs each day or night shift, and the dashboard shows day and night shifts by person and total hours by crew.

Start with the sample fortnight for two crews, then change the names, crews and limits to match your roster. Each shift fills in as 12 hours, so you only pick the date, person, crew and whether the shift is day or night. Check each person's spare hours before you publish the rota, and follow your contract and local rules on rest between shifts, which this sheet does not check.

Useful for

  • Planning a control room rota with two crews on days and nights
  • Checking that each person stays inside their fortnight hours limit
  • Showing how many day and night shifts each person has covered

What's included

  • 4 tabs: Dashboard, Team, Shifts, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Team: a table
  • Shifts: a table
  • 2 charts that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Team tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

Why are the hours fixed at 12?

Each row is one 12-hour shift, so the formula returns 12 for any row with a shift type. If your team works 8-hour or 10-hour shifts, change the formula in that column before you use the file.

How do I roll the file over to a new fortnight?

Duplicate the workbook, empty the rows on the Shifts tab and keep the Team tab. Check that the hours limit still matches your contract for the new period.

Can the sheet show whether someone has enough rest?

Not in this version. It adds up shifts and hours but does not count the rest between a night shift and the next day shift. Plan rest using your organization's rules and check them before you publish the rota.

  • #shift-schedule
  • #12-hour-shift-schedule
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More shift schedule templates

See all 9

Also in Human resources

All human resources templates
Get this template

Preparing your template…