A simple one-week timesheet for hourly employees. The Excel version adds up hours, splits regular and overtime hours for the workweek, and totals gross pay. The PDF is a clean printable form to fill in by hand.
What’s in the template
- Seven rows (one workweek) with time in, lunch out, lunch in and time out
- Automatic daily hours, including shifts that end after midnight
- Weekly regular hours, overtime hours (over 40) and overtime pay at 1.5×
- Gross pay before taxes, plus signature lines for the employee and supervisor
- An example sheet filled in with a realistic week, and a “How to use” tab
How to fill out the weekly timesheet
- Enter the employee name, employer and the first day of the pay period — the dates fill in by themselves.
- Type the hourly rate. Overtime after 40 hours at 1.5× is already set (the federal rule).
- Each day, enter time in, lunch out, lunch in and time out. Leave days off blank.
- Daily hours, weekly overtime and gross pay calculate automatically. Print it or save it as PDF and sign.
Prefer not to use a spreadsheet? The time card calculator does the same math in your browser and exports a PDF or CSV.
Frequently asked questions
Is this timesheet template free?
Yes. Download it, edit it and use it for your business at no cost. No sign-up is needed.
Does the Excel file calculate hours automatically?
Yes. Enter clock-in, lunch and clock-out times and the sheet adds up daily hours, weekly totals, overtime hours and gross pay with formulas. Night shifts that end after midnight are counted correctly.
How is overtime calculated in the template?
It uses the federal FLSA rule: hours over 40 in each fixed 7-day workweek are paid at 1.5 times the regular rate. Weeks are never averaged. Some states add daily overtime, so check your state’s rules.
How long should employers keep timesheets?
Under federal recordkeeping rules, payroll records must be kept for at least 3 years and time cards used to compute wages for at least 2 years (29 CFR 516.5 and 516.6). States can require longer.