A filled-in example day

Example Saturday at a small café. The spreadsheet turns these rows into a half-hour grid.
WhoRoleStartEndBreak
MayaOpener06:0014:0010:30-11:00
TheoBarista07:0015:0011:00-11:30
PriyaRush barista07:0011:00
JordanCloser12:0019:0015:30-16:00
LeeBarista13:0019:0016:00-16:30
Example Saturday at a small café. The spreadsheet turns these rows into a half-hour grid.

The example's need row is 1 before 07:00, 3 until 11:00, 2 until 15:00 and 1 after that. Three people are on from 07:00 to 10:30. Two half hours are highlighted: 10:30, when Maya's break leaves 2 against a need of 3, and 11:00, when Theo's break leaves Maya alone after Priya's rush shift ends. Moving Maya's break to 12:00 and Theo's to 12:30, after Jordan arrives, clears both.

How the grid works

  • Columns run every 30 minutes from the opening time you set.
  • A cell shows W when the person is working, B on break, and stays empty when they're not on shift.
  • The headcount row counts W cells. The need row is yours to fill in, and any half hour below need is highlighted.
  • Shifts must start and end on the same day. For overnight work, use one sheet per calendar day.

When to use a daily schedule

  1. Planning a day that's unlike the rest of the week: a holiday, an event, an inventory count.
  2. Placing breaks so the floor stays covered. The break schedule planner does this automatically.
  3. Posting a shift-by-shift plan for the day at the start of service.