Shift Plan Excel – free & workplace-ready

A professional shift plan clearly shows who works when—with name, date, shift times, and optionally roles or departments. The shift plan Excel template by Ordio offers ready-made columns, automatic working-time calculation, and hour totals per employee. You enter names and shifts—the template calculates the rest. Ideal for 24-hour operations (care, clinics), hospitality, and retail.

A clear plan supports fair rotas, reduces scheduling conflicts, and helps you align with wage and hour rules. In the United States, the Fair Labor Standards Act (FLSA) governs hours, overtime, and records for non-exempt employees; many states add meal breaks and rest rules. In the United Kingdom, the Working Time Regulations 1998 set weekly limits, rest breaks, and daily rest between shifts—planning with adequate gaps between shifts is essential.

The template supports common shift patterns—from early/late splits to three-shift and 24-hour coverage. For simpler weekly planning without rotation, try our duty roster Excel template. Shift model details are below.

Design and content

The template is free and ready to use in Excel or Google Sheets. No registration—download and start immediately. Columns are preconfigured and formulas are installed. Perfect for bakeries (breakfast shifts), clinics (24-hour cover), and hospitality with changing rotas.

The design is deliberately simple: clear columns for names and weekdays, uniform time formats. You stay on top of larger teams. Optionally use colours for shift types (e.g. blue for early, green for late, grey for night)—the template stays flexible.

A professional shift plan always includes: name, date, shift times, and where relevant roles or departments. The Ordio template covers all these elements.

The Ordio template works for all common shift patterns. You enter the times—the template handles calculation and hour totals. No manual formulas required.

The shift model depends on your industry and opening hours: bakeries often use early shifts; clinics and care need 24-hour cover. Three-shift operation is standard in production—early, late, and night rotation. The table below gives an overview.

In 24-hour operations, rest between shifts matters—under UK Working Time Regulations, workers typically need 11 hours daily rest; US state rules may require meal and rest breaks. The template calculates hours so you can spot tight turnarounds. For rotating plans: apply one week's pattern and copy to following weeks.

Adaptation

Customise the shift plan template to your needs: add columns for roles, departments, or locations. Core calculation stays—you adapt the layout. The template supports common time formats—enter times consistently.

Grouping weekdays gives an overview—you see who works each day. For pure hour tracking after shifts are worked, pair this with the time tracking Excel template.

With the Ordio template you plan shifts quickly and with clear hour visibility. Automatic calculation reduces errors in overtime and part-time totals.

Example for 8 employees

Enter names in the first column—for example Alex, Jordan, Sam, Taylor, Morgan, Casey, Riley, and Jamie. For a typical week with early/late splits: Alex and Jordan work Mon-Fri 06:00-14:00; Sam and Taylor 14:00-22:00. Morgan and Casey cover the weekend; Riley and Jamie are on leave.

The template sums hours per person: Alex has 40 hours, Morgan 16—you see if someone approaches overtime under FLSA or high weekly totals under UK rules. When someone is sick: enter cover, the template updates totals. You keep track of leave, illness, and absences—important for fair distribution and compliance.

Assign employees to shifts: start with fixed full-time patterns, then fill gaps with part-time staff. The template shows whether coverage fits.

Reuse and publish

The template is free, needs no registration, and works in Excel or Google Sheets. You save time, reduce mistakes, and stay organised. Save a copy as a template for the next month. Publish rosters early so staff can plan—many US states and UK employers benefit from advance notice even where not strictly mandated.

You can duplicate the shift plan template—for example one sheet per month or department. This keeps history for comparison. For multiple locations or automatic suggestions, Ordio employee scheduling is a cloud-based alternative.

For small teams (up to five people), the shift plan Excel template is often enough. You download the template, add shifts, and you are done. The template is free, works offline, and needs no onboarding. Perfect for getting started with shift planning.

From five employees, planning gets more complex: leave, illness, qualifications, and preferences. Then Ordio employee scheduling is worth considering—the cloud software plans automatically, accounts for all factors, and saves considerable planning time. With mobile apps, employees can view their rota and submit requests. Software complements the Excel template for teams that need more automation.

Many companies in hospitality, retail, and care use Ordio. Start with the free Excel template and move to the full version when your team grows. Ordio time tracking connects seamlessly to scheduling—plan and record hours in one system. No double entry. The template remains useful as backup or for smaller departments.

Typical shift-planning mistakes cost time, money, and morale. Many teams plan in Excel for years and overlook wage and hour gaps until an audit or employee complaint.

Common pitfalls

Publish rosters early enough for staff to plan. The Ordio template helps you avoid:

• Insufficient rest between shifts: UK Working Time Regulations typically require 11 hours daily rest; US state rules may require meal and rest breaks. If a shift ends at 22:00, the next should not start before 09:00. The template highlights tight turnarounds—manual planning can miss these, especially on night rotas.
• Late publication: If you publish the next week on Friday, there is little buffer for call-outs. Plan at least one to two weeks ahead and export as PDF in time.
• Overtime overlooked: Under FLSA, non-exempt US employees earn overtime after 40 hours in a workweek. Without automatic totals, teams exceed limits unnoticed—with payroll and compliance consequences. The template warns you in time.
• Double bookings: Two employees assigned to the same shift? This happens quickly when planning manually. The template shows all shifts at a glance—check before publishing. Especially common with shift swaps or cover.
• Unfair distribution: Always the same people on weekends or nights? This leads to dissatisfaction. Use rotating patterns and document distribution—the template helps you keep overview.
• Minimum wage gaps: UK NMW/NLW and US federal/state minimum wage require correct hourly rates—hour totals from the template support payroll review.

With the Ordio template

With the Ordio shift plan template you significantly reduce planning errors. Automatic calculation and totals save rework and compliance risk.

Tip: Review rest gaps and hour totals before publishing—a short check prevents later corrections. The template does not replace legal advice but helps you keep key requirements visible.

Operating in Germany? German working-time rules differ—add local checkpoints with your adviser if you run a German site.

The Excel template is ideal for getting started and small teams. Many companies ask: stay with Excel or switch to software? The answer depends on team size, planning complexity, and requirements.

Stay with the template when

You have up to five employees, planning is manageable, and you do not need automatic suggestions. The template is free, works offline, and needs no onboarding. Perfect for bakeries, small restaurants, or trades with stable shift patterns. Also often sufficient for retailers with fixed opening hours or practices with set appointment slots. You have full control over the file—no subscription or monthly costs.

Switch to software when

Your team grows (from five to eight or more), leave and absences complicate planning, or you coordinate several locations. Ordio employee scheduling plans automatically, accounts for preferences and qualifications, and saves considerable planning time. Integration with time tracking eliminates double data entry. Employees view their rota, submit requests, and apply for leave in an app. You get conflict alerts and can replan in a few clicks.

The switch is possible at any time: start with the free template, test software as needed, and move when it fits. Both options support US FLSA and UK Working Time Regulations awareness through clear hour totals and published rotas.

Many companies use the template in parallel: Excel for small sites or departments, Ordio for the main operation. Moving from template to software usually takes only a few days. Ordio offers a free trial so you can try the software without obligation.