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.

| Measure | Sample result |
|---|---|
| One V1 shift | 7 h 30 min |
| Deniz’s weekly net time | 37 h 30 min |
| Deniz’s days off | 2 |
How do you start with your own data?
- Enter the Monday date on EN Plan.
- Define shift start, end and unpaid break, then enter the code for each employee and day.
- Resolve check-column warnings and compare net hours with the team plan.