How is working time tracked for night shift employees?
06.09.2026
Night shift working time is the part of attendance calculation that goes wrong most often. The reason is technical: the shift falls across two calendar days and a simple formula does not process that correctly. This guide explains how a night shift is recorded, which rules must be defined in advance, and how it should appear in the report.
The core problem: the day boundary
The shift starts at 22:00 and ends at 06:00. Subtracting the entry time from the exit time gives a negative result, because the date has changed.
The correct approach: the shift is counted as a whole and assigned to the day it started on. So a 22:00–06:00 shift is written entirely into the first day's timesheet.
The alternative - splitting the hours across two days - is technically possible but makes the report unreadable: half a shift appears on each day and overtime cannot be calculated.
Rules that must be defined
- The day the shift belongs to - the starting day or the finishing day.
- The night-hours boundary - which hours count as night time.
- The break - how it applies during a night shift.
- Overtime - calculated against the shift norm.
- Shift handover - who gets the overlapping time.
When these five rules are unwritten the same questions repeat every month and the calculation rests on personal judgement.
A sample calculation
| Date | In | Out | Belongs to | Hours | Note |
|---|---|---|---|---|---|
| 10 → 11 | 22:00 | 06:00 | 10 | 8:00 | Standard shift |
| 12 → 13 | 21:45 | 06:30 | 12 | 8:45 | 45 min overtime |
| 14 → 15 | 22:10 | 06:00 | 14 | 7:50 | 10 min late |
The table shows that without the "belongs to" column the report cannot be read.
A practical example
At a manufacturing plant the night shift was written into Excel as two rows: 22:00–24:00 on the first day and 00:00–06:00 on the second.
Technically that was correct, but it created two problems. First, the monthly day count looked higher than reality - one shift was counted as two days. Second, overtime could not be calculated, because no single row reflected the full shift.
After the rule was changed - the shift as a whole, assigned to the starting day - the report became readable. More importantly, the overtime calculation became automatic and hours that had previously been lost came to light.
The night supplement
Many companies apply a supplement for night hours. For that the report must show not only the total hours but the share falling within the night window. In other words, how many hours of a 22:00–06:00 shift fall into night time must appear in its own column.
Without that column the payroll team performs the calculation by hand every month.
Health and norms
A night pattern is more sensitive from the standpoint of compliance:
- Minimum rest between shifts.
- The maximum number of consecutive night shifts.
- Fair distribution of night shifts across the team.
The last indicator has a long-term effect: when a permanent night pattern stays with one group, staff turnover rises.
The recording point question
A practical detail applies to night shifts: the recording point must be lit and accessible. In terminal-based systems this occasionally causes problems. At a code-based point the matter is simple - the code is placed at the post or near the entrance.
Separating night hours
The second important element of night shift recording is calculating the share of night hours, because a pay supplement usually applies to them.
Two things are needed. The first is defining the boundaries of night time - which hours count as night. The second is the calculation being able to split the shift according to those boundaries.
An example: in a 20:00–08:00 shift the total is 12 hours, but if the night boundaries are 22:00–06:00 then the night portion is 8 hours. Both figures should appear separately in the report.
Without that column the payroll team recalculates by hand every month - and errors arise precisely there, because the calculation depends on the shift length and its start time.
Verifying this capability during system selection is a practical recommendation.
Rest between shifts
Under a night pattern compliance with norms must be monitored more closely, and the key indicator is the rest period between shifts.
The problem usually arises at a shift change: an employee finishes a night shift and returns for a day shift shortly afterwards. When the schedule is written this can go unnoticed, particularly in the case of a swap.
In electronic recording the check runs automatically: at the moment the schedule is written or changed, the system calculates the rest period and warns when it is breached.
In a manually managed schedule the breach usually surfaces at month end - when the report is prepared - and by then it cannot be corrected.
The second indicator to track is the number of consecutive night shifts; this is both a regulatory and a health matter.
The recording point and practical details
Several practical details on the technical side of night shift recording are frequently overlooked.
Lighting. The recording point must be visible at night. In terminal systems the screen provides its own light; a printed code requires illumination.
Shift handover. Two employees check in consecutively at the same point; the system must separate entry from exit correctly.
A lone worker. On a night shift there is often one person on site with nobody supervising - recording discipline is secured by the system alone.
The morning change. When the night shift ends, its check-out and the day shift's check-in fall within the same minutes; the report must be able to separate them.
These four details should be tested during the trial period.
Verifying the calculation
Three scenarios are enough to verify night shift recording, and all three occur in real companies.
A standard shift. Does 22:00–06:00 appear as one row in the timesheet and is it assigned to the starting day?
An extended shift. If the check-out is at 06:30, are the extra 30 minutes calculated as overtime?
The month boundary. Which month does a shift starting on the last day of the month belong to? In practice this is the case handled incorrectly most often, and it directly affects the pay period.
These three scenarios should be verified during system selection - correcting them afterwards is both difficult and disruptive to past reports.
In summary
Recording working time on a night shift rests on one rule: the shift is counted as a whole and assigned to the day it started on. Without that rule the report cannot be read and overtime cannot be calculated.
Beyond that, the share of night hours must be shown separately and the rest between shifts must be checked automatically. Both are essential for the pay supplement and for compliance with the norms.
The next step
To check your current recording, take one night shift from last month's timesheet and follow how it appears. If it shows as two rows or the hours come out negative, the calculation rule needs correcting.
QRGate processes a night shift as a whole unit and shows night hours separately. See what QRGate can do or calculate the price.
