Monthly Shift and Hours Tracker
Compare planned and actual hours by employee and site. Allocate shifts and breaks across month boundaries.
Macro-free .xlsx · Includes a worked example
Results from the sample workbook
- Planned and actual hours
- 13 / 13 h
- P-101 variance
- +1 h
- P-102 variance
- −1 h
Who can use it, and for what?
Multi-site operations
Trace monthly hour variances from the whole team down to each employee and site.
Manufacturing, security and logistics
Allocate month-end night shifts to the correct month when reconciling hours.
A worked example from the workbook
In the December example, planned and actual team hours are both 13. P-101 worked one extra hour and P-102 worked one hour less. These differences remain visible with an unchanged team total.

| Measure | Sample result |
|---|---|
| Planned and actual hours | 13 / 13 h |
| P-101 variance | +1 h |
| P-102 variance | −1 h |
How do you start with your own data?
- Review Ornek - Example and open Plan - Blank for your own entries.
- Enter the report month, employee and site IDs, and planned and actual timestamps. Enter both endpoints for any break.
- Check row errors and read summaries by employee, site and team separately.