Skip to content
Nurse Shift Schedule cover: a sample sheet with shifts booked, hours booked and night shifts and a bar chart, beside the Dashboard, Roster and Nurses tabs

Nurse 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 nurse shift schedule suits charge nurses and ward managers who build the roster for one unit. The Roster tab holds one row per shift with the date, nurse, unit, shift type, hours and status, from Confirmed through Requested to Swap pending. The Nurses tab lists each nurse's contracted hours for the fortnight, works out the hours already booked and shows what is still to book, while the dashboard charts hours by nurse and by unit.

The file opens with a sample fortnight for six nurses, so every total and chart shows real figures. Replace the names, add each shift as you book it and mark a trade as Swap pending until the charge nurse agrees. Any shift over 12 hours turns red, and a nurse booked above contract is highlighted on the Nurses tab, so you can rebalance before the roster goes out.

Useful for

  • Building a fortnightly roster for a medical or surgical ward
  • Checking that part-time nurses are not booked above contract
  • Tracking night shifts and shift swap requests

What's included

  • 4 tabs: Dashboard, Roster, Nurses, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Roster: a table
  • Nurses: 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 Roster 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

How do I track shift swaps between nurses?

Set the status of the shift to Swap pending, then change it to Confirmed once both nurses and the charge nurse agree. The dashboard counts the swaps still waiting, so nothing stays open for long.

Can I use it for shifts longer than 12 hours?

Yes. Type the real hours in the Hours column. The red highlight only flags rows over 12 hours, so change that rule if your unit works longer shifts. Check your unit's own rules on rest breaks as well.

Does the sheet check rest between shifts?

No. It adds up hours and counts shifts, but it does not check rest periods or staffing ratios. Check your hospital's policy and any local rules before you publish a roster.

  • #shift-schedule
  • #nurse-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…