Apollo's Templates
HomeBusinessTimesheet TemplatesBiweekly
Two weeks, one sheet

Biweekly Timesheet Template

Built for the most common American pay schedule: two Monday-through-Sunday week blocks on one page — lunch-break columns included — each with its own overtime subtotal — because federal overtime is figured inside each workweek, never averaged across the period. Enter the period's first date and an hourly rate; the Excel version handles the rest, down to gross pay.

The pay-period sheet

One download, three formats.

Excel — formulas included

Enter the period's first Monday once; both week blocks date themselves. Each week splits its own overtime, then the period totals regular, overtime, and gross pay.
Biweekly timesheet with two week blocks, lunch-break columns, per-workweek overtime subtotals, and period pay
PDF

Printable PDF

Both weeks on a single page with per-week subtotal rows — made for the payroll folder.
Download PDF
Biweekly timesheet with two week blocks, lunch-break columns, per-workweek overtime subtotals, and period pay
Microsoft Word

Word (.docx)

Editable two-week table for typing times in Word. Totals are yours to add — Word doesn't do math.
Download Word
How the split works

A 50-hour week can't borrow from a 30-hour one.

Here’s the arithmetic the sheet automates, using a real pattern: week one is 50 hours, week two is 30. The period totals 80 — exactly two 40-hour weeks — and it is still notan overtime-free paycheck. Week one contributes 40 regular hours plus 10 overtime hours at 1.5×; week two contributes 30 regular. The period’s summary rows show 70 regular, 10 overtime.

If your crew’s hours never cross 40 in a week, the split simply never activates and the sheet behaves like a plain two-week hour log. Nothing to configure either way — that’s the point.

One week at a time
Weekly Timesheet
The single-week version, with a simple in/out variant too.
Open →
Paid on the 1st and 16th
Semi-Monthly Timesheet
Two half-month blocks anchored to dates instead of weekdays — the schedule this sheet can’t serve.
Open →
Live in your Drive
Google Sheets Timesheets
Every sheet as a make-a-copy Google Sheets template.
Browse →

Frequently asked questions

Why is overtime calculated per week instead of over the whole two weeks?
Because federal law says so. The FLSA defines overtime as hours past 40 in a single fixed workweek, and a biweekly pay period is just two of those weeks stapled together for payment convenience. An employee who works 50 hours then 30 gets 10 hours of overtime — averaging the period to 40 and paying no overtime is one of the most common (and most expensive) payroll mistakes. The sheet makes the right answer automatic: each week block runs its own split, then the period sums them.
What's the difference between biweekly and semi-monthly pay?
Biweekly means every second week — 26 pay periods a year, always the same weekday, and this sheet fits it exactly because two whole workweeks fit inside every period. Semi-monthly means twice a calendar month (say the 15th and last day) — 24 periods a year whose boundaries slice through the middle of workweeks. If you're paid semi-monthly, use our semi-monthly timesheet instead — its two blocks anchor to the 1st and the 16th, which is how that schedule actually runs.
Does the sheet assume a particular payday?
No. It anchors to one thing only: the date the period starts, which you type into the “Period starting” field. Both week blocks date themselves from there, Monday through Sunday, and the arithmetic never references a pay date. Whether your employer pays the Friday after the period closes or five business days later, the sheet doesn't care — it records the hours, and payday is between you and the payroll calendar.
Can I use the biweekly sheet in Google Sheets?
Yes — the “Open in Google Sheets” button puts a copy in your own Drive with every formula intact, including the per-week overtime splits. It's the right choice when the sheet is shared: an employee fills in times from their phone during the period, the manager reviews the totals at the end, and nobody emails an attachment back and forth. The copy is yours permanently; we can't see it.
Updated through September 2026