Free shift hours log template
Record when you started, when you finished and how many unpaid break minutes you took. Keep an editable shift log in a spreadsheet, then import it to check the hours on your payslip.
Try a week of overnight and daytime shifts
The worked CSV covers 23–29 November 2026 in the Europe/London time zone. It contains four fictional shifts.
| Start | Finish | Unpaid break | Hours |
|---|---|---|---|
| 35 min | 7:55 | ||
| 0 min | 4:10 | ||
| 45 min | 7:00 | ||
| 20 min | 4:00 |
The last row ends at midnight, just as this pay period closes. If work continues after midnight, record the remaining time in the next period and assign each break to the part where it happened.
Fill in your own shift log
Open the blank CSV in your spreadsheet editor. Keep the three column headings. Format the two time columns as text so the spreadsheet preserves the full date, the letter T and the 24-hour time.
start_at- Full date and time you clocked in, such as
2026-11-23T22:00. end_at- Full date and time you clocked out. Use the next date if your shift ends after midnight.
unpaid_break_minutes- Total unpaid break minutes in that row. Enter
0for a shift with no unpaid break.
Keep one shift per row and export as a comma-separated UTF-8 CSV. The checker accepts up to 200 rows and a 64 KB file. The blank template has just the headings so you can add as many rows as you need within those limits.
Compare the log with your payslip
- Open Shift Hours Check. Set the first and last day of the pay period and choose the time zone where you worked.
- Open Import shifts from CSV and select the file. Review the preview for time or date errors, then choose Add selected shifts.
- Enter the worked-hours figure from your payslip, select the matching hours format and confirm both entries cover the same period. Choose Compare hours. For the sample, enter 22.75 in Decimal hours format.
If a total differs, check the dates, breaks and duplicate shifts. The checker can make a PDF with the shift-by-shift comparison.
Blank shift log
Write the date and time for both ends of each shift, especially when you work past midnight.
| Shift | Start date and time | Finish date and time | Unpaid break (min) |
|---|---|---|---|
| 1 | |||
| 2 | |||
| 3 | |||
| 4 | |||
| 5 | |||
| 6 | |||
| 7 | |||
| 8 | |||
| 9 | |||
| 10 | |||
| 11 | |||
| 12 |
Use Shift Hours Check to compare your log with your payslip. shift-hours-check.pages.dev