Overnight Shift Hours
Change the start, end, and break values to calculate net time. The workbook includes English and Turkish worksheets.
Macro-free .xlsx · Includes a worked example
Results from the sample workbook
- Net overnight shift
- 7.5 hours
- Net same-day shift
- 8 hours
- Unpaid overnight break
- 30 min
Who can use it, and for what?
Businesses with night shifts
Find net shift duration across midnight in security, logistics or manufacturing.
Timesheet and data quality teams
Audit day and night records using full start and end timestamps.
A worked example from the workbook
A shift from 22:00 on 30 November to 06:00 on 1 December lasts eight hours. A 30-minute unpaid break leaves 7.5 net hours.

| Measure | Sample result |
|---|---|
| Net overnight shift | 7.5 hours |
| Net same-day shift | 8 hours |
| Unpaid overnight break | 30 min |
How do you start with your own data?
- Enter full start and end date-times on the English sheet.
- Enter any unpaid break in minutes. A blank means zero.
- Read net hours and resolve any check-column warning.