How to fill in this timesheet
- Enter the employee name, hourly rate and the first day of the pay period.
- Choose weekly or biweekly.
- For each day, enter time in, time out and unpaid break minutes. Overnight shifts work: a time out earlier than the time in counts past midnight.
- Check the weekly totals, then download for signatures and payroll.
Minutes to decimal hours
| Minutes | Decimal | Minutes | Decimal |
|---|---|---|---|
| 6 | 0.10 | 12 | 0.20 |
| 15 | 0.25 | 20 | 0.33 |
| 30 | 0.50 | 40 | 0.67 |
| 45 | 0.75 | 50 | 0.83 |
Divide minutes by 60. So 7 hours 45 minutes is 7.75 hours, not 7.45.
What federal law requires you to keep
- Hours worked each day and each workweek
- The regular hourly rate and total overtime pay
- Total wages for each pay period and the pay date
- The employee's name, address and job title
Overtime basics
Overtime is 1.5× the regular rate, which includes non-discretionary bonuses and shift differentials, not just the base wage. California, Alaska, Nevada and Colorado also have daily overtime rules, and California requires double time in some cases. Check your state before relying on weekly totals alone.
Timesheets for freelancers
If you bill by the hour, use the same sheet to track client work, then carry the hours onto an invoice. Ignore the overtime split, since it doesn't apply to contractors.
When time tracking needs GPS clock-ins, approvals or automatic payroll sync, dedicated software is worth it. Until then, this sheet and the payroll calculator cover the basics.