The sheet's columns

Columns on both the PDF and the spreadsheet
ColumnWhat goes in it
DateThe day the shift started
NamePrinted, so it can be read later
Time inWhen work started, written as it happened
Break out / Break inThe unpaid break, if taken
Time outWhen work ended
HoursSpreadsheet only: calculated
SignatureThe employee's initials
CheckedA manager's initials at the end of the week
Columns on both the PDF and the spreadsheet

The example rows in the spreadsheet

Example lines and the hours the spreadsheet calculates
DateNameInBreakOutHours
Mon 3/8Maya05:5810:30-11:0014:057.62
Mon 3/8Jordan13:5517:00-17:3022:107.75
Fri 3/12Sam22:0002:00-02:3006:308.00
Sat 3/13Priya07:0211:003.97
Example lines and the hours the spreadsheet calculates

Maya's line is 05:58 to 14:05, 8 hours 7 minutes, minus a 30-minute break: 7 hours 37 minutes, 7.62 decimal hours. Sam's night shift ends after midnight; the spreadsheet adds a day when the time out is earlier than the time in.

Rules for a paper sign-in sheet

  • Write the actual time, not the scheduled time. A sheet where every line says 9:00 to 5:00 isn't a record of hours worked.
  • Use a pen, and cross out mistakes with a line and initials rather than writing over them.
  • One sheet per week, collected and checked before payroll.
  • Keep the sheets. Federal rules require records of hours worked to be kept; Fact Sheet 21 lists what's needed.

If you're deciding whether to move off paper, paper timesheets vs a time clock app compares the two on accuracy and time spent. To total a single person's week, use the time card calculator.