Please note: This template is general guidance, not legal or HR advice. Employment laws vary by state, so check your obligations before using it.
Download this template free
No sign-up needed. Word and Excel files also open in Google Docs, Google Sheets and Apple Pages/Numbers. Letter size (8.5 × 11 in).
Weekly Timesheet
| Day | Date | Time in | Unpaid break (hrs) | Time out | Hours worked | Notes |
|---|---|---|---|---|---|---|
| Monday | ||||||
| Tuesday | ||||||
| Wednesday | ||||||
| Thursday | ||||||
| Friday | ||||||
| Saturday | ||||||
| Sunday | ||||||
| Total |
| Total hours | |
|---|---|
| Overtime hours (over 40) | |
| Regular hours | |
| Hourly rate | |
| Gross pay (OT at 1.5×) |
Enter hours worked each day (for example 8 or 7.5). Overtime over 40 hours is calculated automatically. Some states, such as California, also require daily overtime.
I certify that the hours above are accurate and complete.
Employee
Supervisor
Preview of the template. Highlighted [brackets] show text to replace.
How to fill in the timesheet
- Enter the employee details and the date the week starts.
- For each day, record time in and time out, plus any unpaid break.
- Enter the hours worked in decimal format, such as 7.5 for seven and a half hours.
- Check the totals. The Excel version adds up the week. Anything over 40 hours is counted as overtime automatically, and the template splits regular and overtime pay.
- Sign and approve. The employee certifies the hours and the supervisor approves them.
Minutes to decimal hours
| Minutes | Decimal | Minutes | Decimal |
|---|---|---|---|
| 5 | 0.08 | 35 | 0.58 |
| 10 | 0.17 | 40 | 0.67 |
| 15 | 0.25 | 45 | 0.75 |
| 20 | 0.33 | 50 | 0.83 |
| 25 | 0.42 | 55 | 0.92 |
| 30 | 0.50 | 60 | 1.00 |
Example
Jamie works 9:00 a.m. to 5:30 p.m. Monday to Friday with a 30-minute unpaid lunch, plus 4 hours on Saturday. That is 8 hours a day for 5 days (40 hours) plus 4 hours, for 44 hours total. At $20 an hour, gross pay is 40 × $20 + 4 × $30 = $920.
Timesheet tips
- Record time daily, not at the end of the week from memory.
- Use a consistent workweek, such as Sunday to Saturday, and do not change it to avoid overtime.
- Approve timesheets promptly so payroll runs on time.
- Freelancers can use the same template to log billable hours, then transfer them to a freelance invoice.
Frequently asked questions
When do employees earn overtime?
Under federal law (the FLSA), non-exempt employees must be paid at least 1.5 times their regular rate for hours worked over 40 in a workweek. Some states have stricter rules. California, for example, also requires daily overtime after 8 hours.
Do unpaid lunch breaks count as hours worked?
Bona fide meal breaks, usually 30 minutes or more during which the employee is fully relieved of duty, do not have to be paid under federal law. Short rest breaks of 5 to 20 minutes generally must be paid. State rules vary.
How do I convert minutes to decimal hours?
Divide the minutes by 60. For example, 15 minutes is 0.25 hours, 30 minutes is 0.5 and 45 minutes is 0.75. So 7 hours and 45 minutes is 7.75 hours.
How long should I keep timesheets?
The FLSA requires employers to keep time cards and records used to compute wages for at least two years, and payroll records for at least three years. Some states require longer.
Related templates and guides
Employee Onboarding Checklist
Everything a new hire needs, from offer to day 90, including the federal paperwork US employers must complete.
TemplateFreelance Invoice Template
Built for freelancers and independent contractors who bill by the hour or by project. Includes a project reference, hourly rates and space for your payment links.
TemplateFree Invoice Template
A clean, professional invoice that works for almost any small business. The Excel version calculates line totals, sales tax and the amount due for you.
TemplateEmployee Handbook Outline
A section-by-section outline for a small business employee handbook, with prompts for each policy and a signed acknowledgment page.