The sheet's columns
| Column | What goes in it |
|---|---|
| Date | The day the shift started |
| Name | Printed, so it can be read later |
| Time in | When work started, written as it happened |
| Break out / Break in | The unpaid break, if taken |
| Time out | When work ended |
| Hours | Spreadsheet only: calculated |
| Signature | The employee's initials |
| Checked | A manager's initials at the end of the week |
The example rows in the spreadsheet
| Date | Name | In | Break | Out | Hours |
|---|---|---|---|---|---|
| Mon 3/8 | Maya | 05:58 | 10:30-11:00 | 14:05 | 7.62 |
| Mon 3/8 | Jordan | 13:55 | 17:00-17:30 | 22:10 | 7.75 |
| Fri 3/12 | Sam | 22:00 | 02:00-02:30 | 06:30 | 8.00 |
| Sat 3/13 | Priya | 07:02 | 11:00 | 3.97 |
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.