Biweekly Timesheet Calculator
Fourteen decimal-hour rows for one pay period. Week 1, Week 2, and the period total stay separate. Weekly overtime and pay-period overtime are two different counts, shown next to each other.
14-day timesheet
The sample rows are five 8-hour days in Week 1 and five 9-hour days in Week 2. Replace them with the hours you have. Blank punches belong on the 2-week time card.
| Day | Decimal hours |
|---|---|
| Week 1 Mon | |
| Week 1 Tue | |
| Week 1 Wed | |
| Week 1 Thu | |
| Week 1 Fri | |
| Week 1 Sat | |
| Week 1 Sun | |
| Week 2 Mon | |
| Week 2 Tue | |
| Week 2 Wed | |
| Week 2 Thu | |
| Week 2 Fri | |
| Week 2 Sat | |
| Week 2 Sun |
Weekly overtime and pay-period overtime
Weekly overtime looks at each workweek on its own. Hours in Week 1 above the threshold you typed, plus hours in Week 2 above that same threshold, are the weekly overtime hours. A short Week 2 does not give back the extra hours from Week 1.
Pay-period overtime looks at the 14-day total. It counts hours above twice the weekly threshold. A long Week 1 and a short Week 2 can cancel inside this second definition. They do not cancel inside the first.
The two numbers sit side by side so you can see the gap. They are not added. They are not averaged. Pay, daily overtime, a seventh-day premium, and double time are outside this grid. The overtime calculator can sketch gross pay from one weekly hour total after you already know which definition you are using.
Where the two totals split
Threshold typed as 40. Week 1 is 45.00 hours and Week 2 is 35.00 hours. The pay period is 80.00 hours.
Weekly overtime is 5.00 from Week 1 plus 0.00 from Week 2, which is 5.00. Pay-period overtime is 80.00 minus 80.00, which is 0.00. The same timesheet, two definitions.
The sample loaded in the grid is a different pair: Week 1 is five 8-hour days (40.00) and Week 2 is five 9-hour days (45.00). Weekly overtime is 0.00 plus 5.00. Pay-period overtime is 85.00 minus 80.00, also 5.00. In that sample the two methods match. Change Week 1 to 45 and Week 2 to 35 if you want the split on screen.
Hours here, punches on the 2-week card
This timesheet starts from decimal hours you already trust for each day. It does not ask for clock-in, clock-out, or a lunch stamp. Those fields are on the 2-week time card calculator, which also prints Week 1, Week 2, and a period total as H:MM and decimal. Use that page to build the day totals, then use this page when the question is which overtime definition the 14 days fall under.
A single week with a CSV export stays on the timesheet calculator. One shift stays on the time card calculator.
FAQ
What is a biweekly timesheet?
A biweekly timesheet lists hours for one pay period of two workweeks, usually 14 calendar days. This page keeps Week 1, Week 2, and the pay-period total as three separate numbers.
How is weekly overtime different from pay-period overtime?
Weekly overtime adds the hours over your typed threshold in Week 1 to the hours over that same threshold in Week 2. Pay-period overtime looks at the 14-day total and counts hours over twice the threshold. The two methods are different definitions. This page shows both and does not add them together.
What if week 1 is over the threshold and week 2 is under?
With a typed threshold of 40, a 45-hour Week 1 and a 35-hour Week 2 produce 5.00 weekly overtime hours and 0.00 pay-period overtime hours, because 80 hours is exactly twice 40. The extra week-1 hours are offset inside the pay-period method. They are not offset inside the weekly method.
Does this page decide which overtime rule applies?
No. You type the weekly hour threshold. Daily overtime, seventh-day rules, and double time are not calculated. Confirm the method with the employer policy that covers the job.
Can I enter clock in and clock out here?
This grid takes decimal hours already worked for each day. For In, Out, and unpaid break minutes across 14 rows, use the 2-week time card calculator, then bring the day totals here if you want the two overtime definitions side by side.
What threshold should I type?
Type the weekly hour number your payroll uses. The field starts at 40 only as a blank-form example. It is not a statement of federal or state law.