Timesheet Overtime Calculator

How timesheet entries become overtime estimates

This calculator is for users who do not already know their overtime hours. Instead of entering overtime hours directly, you enter one in time, one out time, and unpaid break minutes for each day using a 12-hour clock. Time fields start blank, break fields start at 0 minutes, and the calculator converts each day into hours, subtracts breaks, totals the week, and then splits the total into regular and overtime hours.

The default weekly threshold is 40 hours because many U.S. federal overtime examples use a weekly workweek threshold for covered nonexempt employees. Some states, local rules, union agreements, or employer policies may use daily overtime, weekly overtime, or both. Adjust the threshold if you are estimating a different scenario.

Recent timesheet entries are saved locally in your browser for convenience. They are not sent to a server by this static calculator. Use the reset button if you want to clear the saved entries and return to the default example.

Timesheet overtime method

Times can be entered as 8, 80, 800, 0800, 8:00, or 08:00 with the am or pm selector. The calculator waits until you leave a time field before formatting it as hh:mm, so you can finish typing without the value changing under your cursor. The calculator treats an out time earlier than or equal to the in time as an overnight shift ending the next day.

Break minutes are subtracted from daily time. If break minutes exceed worked time for a day, the calculator prevents negative daily hours and displays a validation message. The result report shows daily hours in hh:mm and decimal formats, then summarizes regular hours, overtime hours, hourly rates, and gross pay in a weekly totals table.

dailyHours = max((outTime - inTime) - unpaidBreakMinutes / 60, 0)
weeklyTotalHours = sum(dailyHours)
regularHours = min(weeklyTotalHours, weeklyOvertimeThreshold)
overtimeHours = max(weeklyTotalHours - weeklyOvertimeThreshold, 0)
regularPay = regularHours x hourlyRate
overtimePay = overtimeHours x hourlyRate x overtimeMultiplier

Weekly threshold example

Suppose you work Monday through Friday from 09:00 am to 05:30 pm with a 30-minute unpaid break each day. Each day counts as 8.00 paid hours, for a weekly total of 40.00 hours. With a 40-hour threshold, the weekly overtime hours are 0.

If you add a Saturday shift from 09:00 am to 02:00 pm, the weekly total becomes 45.00 hours. With a 40-hour weekly threshold, regular hours are 40.00 and overtime hours are 5.00.

When to use this calculator

Use this calculator when clock times matter. It is useful for weekly recordkeeping, checking a handwritten timesheet, subtracting unpaid breaks, handling overnight shifts, or converting hours and minutes into a payroll-style decimal result.

If you already know total hours and only need to split regular and overtime hours, use the overtime hours calculator. If you prefer an offline spreadsheet, use the overtime calculator Excel template.

What this calculator does not cover

The calculator uses one weekly threshold. It does not apply every daily overtime rule, seventh-day rule, split-shift rule, rounding rule, meal-period rule, paid leave rule, or industry-specific rule. If your location or employer uses daily overtime, review the result carefully and adjust outside the calculator as needed.

It also does not determine whether hours are compensable, whether a break is unpaid, whether travel or on-call time counts, or whether a worker is exempt or nonexempt.

Common mistakes and limitations

A common mistake is entering break time as hours when the field expects minutes. Enter 30 for a 30-minute break, not 0.5. Time entries may include or omit the leading zero, and compact entries such as 8, 80, or 800 are normalized to 08:00 after you leave the field.

Timekeeping systems may round entries under specific policies. This calculator uses the exact in and out times entered, so its result may differ from a system that rounds to the nearest tenth, quarter hour, or another interval.