Biweekly Timesheet Calculator
A two-week timesheet that does the arithmetic: daily hours from clock-in and clock-out, unpaid breaks removed, totals per week and per pay period, decimal hours for payroll, and gross pay if you enter a rate. Overtime, if you turn it on, is worked out week by week — the way employment-standards laws require.
| Week 1 | In | Out | Break (min) | Hours |
|---|---|---|---|---|
| Mon | — | |||
| Tue | — | |||
| Wed | — | |||
| Thu | — | |||
| Fri | — | |||
| Sat | — | |||
| Sun | — | |||
| Week 1 total | 0.00 | |||
| Week 2 | In | Out | Break (min) | Hours |
|---|---|---|---|---|
| Mon | — | |||
| Tue | — | |||
| Wed | — | |||
| Thu | — | |||
| Fri | — | |||
| Sat | — | |||
| Sun | — | |||
| Week 2 total | 0.00 | |||
Pay period total
Official sources
Limitations
- Only one shift per day. For split shifts, add the two shifts in the hours calculator and enter the total as one row (start 0:00, end = total hours).
- The Ontario overtime option assumes you are not in an exempt job and have no averaging agreement.
- Nothing is saved on our side — print or screenshot the page if you need a record.
Results are estimates for general information and are not legal, tax, payroll or financial advice. Employment contracts, collective agreements and individual circumstances can change what you are owed.
How totals are calculated
day hours = (out − in − unpaid break) ÷ 60 week hours = Σ day hours (7 days) overtime = max(week hours − threshold, 0) ← per week, if enabled gross pay = Σ (regular hours × rate + overtime hours × rate × multiplier)
Worked example — Ontario, $20/hour
| Week | Hours | Regular | Overtime | Pay |
|---|---|---|---|---|
| 1 (5 × 10 h) | 50.00 | 44 × $20 = $880 | 6 × $30 = $180 | $1,060.00 |
| 2 (4 × 9.5 h) | 38.00 | 38 × $20 = $760 | 0 | $760.00 |
| Period | 88.00 | 82 h | 6 h | $1,820.00 |
Tips for accurate timesheets
- Record the time you actually started and stopped working, not your scheduled shift. Time you are required to be on site counts.
- Only subtract breaks that are unpaid. If you worked through lunch, do not subtract it.
- Keep your own copy. If pay is ever disputed, your contemporaneous record matters.
Related
- Hours calculator for a single day with multiple shifts.
- Ontario gross pay checker to add holiday pay and vacation pay to these hours.
- Hourly to salary converter to see what the rate works out to per year.
Frequently asked questions
Why is overtime calculated per week and not for the whole two weeks?
Employment standards in Ontario (and most of Canada) define overtime per work week. 50 hours in week one and 38 in week two gives 6 overtime hours, even though the period total of 88 is exactly 2 × 44. Only a written averaging agreement lets an employer combine weeks.
How do I enter a night shift?
Enter the clock-in time and the clock-out time as normal (for example 23:00 and 7:00). An out time earlier than the in time is treated as the next day.
What does the “decimal hours” figure mean?
Payroll software multiplies decimal hours by your rate. 38 hours 45 minutes is 38.75 decimal hours. We round to two decimals.
Can I use this for a weekly or monthly pay period?
For weekly pay, fill in week 1 only. For semi-monthly or monthly pay, run the calculator once per two-week block and add the totals.