Restaurant Employee Schedule Template (Excel) — Auto-Calculates Hours, Overtime & Pay

Stop rebuilding the schedule math every week.

This Excel template gives restaurant managers a weekly staff schedule that calculates itself. Type a shift code into a cell — OPEN, MID, CLOSE, or DOUBLE — and the template instantly works out each employee's daily hours, weekly hours, overtime, and pay. Change the shift times once and every schedule that uses them updates automatically.

What's inside

• Instructions tab — a styled walkthrough of setup in 6 steps, plus a color-coded legend so you always know which cells are safe to edit.
• Shift Codes tab — define your restaurant's actual OPEN, MID, CLOSE, and DOUBLE shift times in one place (2 spare rows included for your own custom codes).
• Weekly Schedule tab — the working grid: 13 employee rows, all 7 days, a dropdown for shift-code entry, and columns for weekly hours, overtime hours, hourly rate, and weekly pay — all calculated, none of it typed in by hand.

Why it's different

• Built-in overtime math. Hours past 40/week automatically calculate at a 1.5× premium in the pay total — no separate spreadsheet, no manual math.
• Dates move with you. Enter the Monday date once and every day-of-week header updates to match — duplicate the tab for next week in two clicks.
• Daily coverage at a glance. A built-in headcount row shows how many staff are scheduled each day, so gaps in coverage are obvious before they become a problem.
• Edit-safe by design. Amber cells are yours to fill in, black cells are automatic formulas, and emerald cells are your key totals — color-coded so nothing gets overwritten by accident.

Who it's for

Restaurant, café, and bar managers who are still scheduling shifts and doing payroll math by hand — or in a spreadsheet that doesn't calculate anything for them. Works for a single location or as a starting point you duplicate per week or per location.

Format

One Microsoft Excel file (.xlsx), 3 tabs, fully editable. Opens in Excel, Google Sheets, and LibreOffice Calc. Includes a readme with full setup instructions.