ExcelFlux
← Workbooks

Weekly Shift Planner

Plan weekly shifts for up to 12 employees. Set shift times and unpaid breaks, then see employee and team totals. The workbook includes blank plans and completed examples in English and Turkish.

Macro-free .xlsx · Includes a worked example

Results from the sample workbook

One V1 shift
7 h 30 min
Deniz’s weekly net time
37 h 30 min
Deniz’s days off
2

Who can use it, and for what?

Store and service managers

See days off and closing shifts in one roster.

Warehouse and production supervisors

Compare team hours and prepare weekly assignments using shift codes.

A worked example from the workbook

In the week of 23 November, Deniz works five V1 shifts from 08:00 to 16:00, each with a half-hour break. With two OFF days the net week is 37 hours and 30 minutes.

Worksheet from the completed Excel sample
View from the Excel workbook. Open the image to enlarge it.
MeasureSample result
One V1 shift7 h 30 min
Deniz’s weekly net time37 h 30 min
Deniz’s days off2

How do you start with your own data?

  1. Enter the Monday date on EN Plan.
  2. Define shift start, end and unpaid break, then enter the code for each employee and day.
  3. Resolve check-column warnings and compare net hours with the team plan.