Biweekly Timesheet Calculator

First workweek boundary:

This boundary controls weekly overtime classification; it may begin on any day and at any hour.

Rule basis:

State, local, occupation, contract, union, and employer rules may differ or be more protective.

Default hourly rate:

$per hour

Shift entries:

Rows stay editable. Use anonymous notes before sharing the URL or an export.

Date	Clock in	Clock out	Unpaid	Rate	Note	Remove
Date	In	Out	Break min	Rate $	Note

Punch rounding:

Exact punches are the neutral default. A nonzero option may change worked time and pay.

Payroll label:

Leave blank for no label; this field changes handoff copy only.

Two-workweek pay review

{{ week.label }}{{ week.dateRange }}

Worked: {{ formatHours(week.totalHours) }}
Regular / overtime: {{ formatHours(week.regularHours) }} / {{ formatHours(week.overtimeHours) }}
Weighted regular rate: {{ formatMoney(week.weightedRate) }}/hr
Estimated gross: {{ formatMoney(week.grossPay) }}

Calculation method:

Gross = straight-time earnings + overtime hours × weighted regular rate × (multiplier − 1)

Each 168-hour workweek is calculated separately; hours are never averaged across the two weeks.

{{ note }}

Week	Date	In–out	Unpaid	Rate	Worked	Regular	Overtime	Straight pay	Note	Copy
{{ row.weekLabel }}	{{ formatDate(row.date) }}	{{ row.start }}–{{ row.end }}	{{ row.breakMinutes }} min	{{ formatMoney(row.rate) }}/hr	{{ formatHours(row.workedHours) }}	{{ formatHours(row.regularHours) }}	{{ formatHours(row.overtimeHours) }}	{{ formatMoney(row.straightPay) }}	{{ row.note \|\| '—' }}

A biweekly pay period contains two weeks, but weekly overtime is still tested one workweek at a time. Under the U.S. federal Fair Labor Standards Act baseline, a covered, nonexempt employee generally earns overtime after 40 hours in a fixed seven-day workweek. A busy first week cannot be averaged against a quiet second week to erase overtime.

The workweek boundary matters as much as the pay-period dates. It may begin on any day and at any hour, and once established it determines which week receives an overnight shift. A shift that crosses that boundary should be split so each part is classified in the correct week.

Worked time is the interval between clock-in and clock-out after subtracting a genuine unpaid break. Optional punch rounding can change both worked minutes and pay, so exact recorded punches are the neutral starting point. Daylight-saving changes are another source of error because ordinary wall-clock subtraction does not know whether an hour was skipped or repeated.

Different hourly rates also change overtime pricing. The federal regular rate is generally based on total includable compensation divided by hours worked in the week. A ledger that contains only hourly shifts can estimate that weighted rate, but bonuses, commissions, tips, paid leave, salary methods, and other payments may require a fuller payroll analysis.

Workweek: A fixed 168-hour period used to classify weekly overtime.
Straight-time pay: All worked hours priced at their entered hourly rates before the extra overtime premium.
Weighted regular rate: The week's straight-time pay divided by its worked hours when more than one hourly rate is present.
Overtime premium: The additional amount above straight-time pay for hours beyond the selected weekly threshold.

This is a planning and audit aid, not a payroll or legal determination. Coverage, exemption status, compensable time, and federal, state, local, contract, union, or employer rules must still be checked.

How to Use This Tool:

Set the workweek before entering shifts so every row falls into the intended weekly overtime test.

Choose the First workweek boundary date and time. The calculator builds two consecutive seven-day weeks from that point.
Select the Rule basis. The federal baseline fixes the weekly threshold at 40 hours and the multiplier at 1.5; custom rules use the values you supply.
Enter each shift's date, clock-in, clock-out, unpaid break, and hourly rate. Split any shift that crosses the workweek boundary.
Leave Punch rounding at exact punches unless a verified policy requires 5-, 6-, or 15-minute rounding. Check the reported rounding difference when a nonzero increment is used.
Review Pay review and the Shift ledger. Confirm the regular and overtime split for each week before relying on gross pay.

Interpreting Results:

Gross pay combines straight-time pay for every worked minute with the additional overtime premium. It does not include taxes, deductions, bonuses, commissions, tips, paid leave, or non-hourly compensation.

Compare Week 1 and Week 2 separately. Overtime in one week is not offset by unused regular hours in the other.
Check Weighted regular rate when shifts use different rates. A simple average of the listed rates is not the same calculation.
Check Rounding difference against the original punches. A positive or negative total shows that rounding changed recorded time.
Treat the result as incomplete if the employee was not fully relieved of duties during a break or receives other includable compensation.

Technical Details:

Each shift is placed in one of two fixed 168-hour workweeks. Clock times may cross midnight, but a rounded shift may not overlap another shift, exceed 24 hours, fall outside the two-week period, or cross the workweek boundary. Unpaid break minutes must be shorter than the rounded shift.

Formula Core:

Within each week, worked minutes are assigned to regular time until the weekly threshold is reached. Remaining minutes are overtime. Straight-time pay prices every worked minute at its shift rate, while the overtime premium uses the week's weighted regular rate.

\begin{array}{lll} W_{i} & = & E_{i} - S_{i} - B_{i} \\ O & = & \max (0, H - T) \\ StraightPay & = & \sum_{i}^{shifts} (\frac{W_{i}}{60} \times r_{i}) \\ r_{w} & = & \frac{StraightPay}{H} \\ GrossPay & = & StraightPay + (O \times r_{w} \times (m - 1)) \end{array}

Biweekly timesheet formula symbols and units
Symbol	Meaning	Unit
W_i	Worked duration for shift i after punch rounding and the unpaid break	minutes
S_i, E_i, B_i	Rounded start, rounded end, and unpaid break for shift i	minutes
H	Total worked time in the current workweek	hours
T	Weekly overtime threshold	hours
O	Overtime time above T	hours
r_i, r_w	Shift rate and weighted regular rate	USD per hour
m	Overtime multiplier	ratio

A two-rate week shows why weighting matters. Eight hours at $20 plus four hours at $30 produce $280 in straight-time pay across 12 hours, so the weighted regular rate is $23.3333 per hour. With an eight-hour threshold and a 1.5 multiplier, four overtime hours add a $46.67 half-time premium, making gross pay $326.67.

Shift straight-time amounts and weekly premium amounts are rounded to cents. Totals add the two weekly results. Punch rounding is applied to start and end times before the unpaid break is subtracted; exact punches apply no time rounding.

Limitations:

The federal baseline does not decide whether an employee is covered or exempt, and more protective rules may apply.
The weighted rate uses only the hourly shift pay entered here. Other compensation and lawful exclusions are outside the model.
Wall-clock arithmetic does not adjust for daylight-saving transitions.
A payroll professional or applicable labor authority should resolve disputed compensable time, break treatment, or regular-rate inputs.

References:

Fact Sheet #56A: Overview of the Regular Rate of Pay Under the FLSA, U.S. Department of Labor, December 2019.
29 CFR Part 778—Overtime Compensation, Electronic Code of Federal Regulations.
29 CFR § 785.48—Use of time clocks, Electronic Code of Federal Regulations.