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.

StartFinishUnpaid breakHours
35 min7:55
0 min4:10
45 min7:00
20 min4: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 0 for 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

  1. Open Shift Hours Check. Set the first and last day of the pay period and choose the time zone where you worked.
  2. Open Import shifts from CSV and select the file. Review the preview for time or date errors, then choose Add selected shifts.
  3. 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.

Name or initialsPay periodWork time zone
ShiftStart date and timeFinish date and timeUnpaid 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

Worked example

Open Shift Hours Check