Shift Rota & Staff Schedule (Excel)

Plan every shift in minutes, not hours.

Pick a shift code for each person and day. Hours, staff costs and daily cover are worked out for you, and short-staffed shifts turn red before they become a problem. No macros.

WHAT IT DOES

• 4 weekly rotas for up to 30 staff

• 12 colour-coded shift codes you can set up (Early, Late, Night, Long day, Holiday, Sick and your own)

• Night shifts past midnight worked out correctly, with unpaid breaks

• Hours, days worked and staff cost for every person

• Contracted vs actual hours (+/-), so you can see who's doing extra and who's short

• Daily cover: who's on each shift, with red warnings when you're below your minimum

• Staff working, paid hours, and staff cost for every day

• 4-week summary with totals and 2 charts

• Today's date highlighted

• Start Here guide and an example rota

WHO IT'S FOR

Cafés, bars and restaurants, shops and small businesses, care homes, and any team that works shifts.

GOOD TO KNOW

• Works in Microsoft Excel: Microsoft 365, Excel 2010 or later on Windows, and Excel for Mac

• Normal .xlsx file: no macros to enable

• One-off payment, instant download

Made by Lee at Sheet Leveller, whose tutorials have been watched 6.3 million times on YouTube.