For businesses that pay every two weeks. The template keeps the two workweeks apart, because federal overtime is calculated for each 7-day workweek — 30 hours one week and 50 the next means 10 overtime hours, not zero.
What’s in the template
- Fourteen rows with time in, lunch out, lunch in and time out
- Week 1 and week 2 totals, each with its own overtime
- Pay-period totals and gross pay before taxes
- Example sheet and step-by-step instructions
How to fill out the biweekly 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.
You can also use the biweekly time card calculator online.
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.