Timesheet Calculator: Weekly Hours, Overtime and Pay
Add up a week of work: same hours every day or a start and end time for each day, unpaid breaks, clock rounding, overtime (US 40-hour, California daily or Mexico rules) and gross pay.
How it works
paid hours per day = (end − start) − unpaid break · weekly hours = sum of the days · weekly overtime = hours over the threshold · pay = regular hours × rate + overtime hours × rate × multiplier
Choose “Same every day” for a fixed schedule (hours per day × days per week), or “Day by day” to type a start and end time for each day like a time card. The unpaid break is taken off every worked day; in day-by-day mode you can give a single day its own break by adding the minutes after the times. A shift that ends earlier than it starts is treated as running past midnight. Overtime follows the rule you pick. The US federal rule (FLSA) pays at least 1.5× for hours over 40 in a fixed 7-day workweek, with no daily overtime; you can change the threshold and multiplier for a union or company rule. The California option applies 1.5× after 8 hours in a day and after 40 regular hours in a week, 2× after 12 hours in a day, and the seventh-consecutive-day rule when all seven days are worked. The Mexico option follows the Ley Federal del Trabajo as reformed on 1 May 2026: hours beyond the legal week (48 in 2026, then 46, 44, 42 and 40 from each January 2027 to 2030) are overtime; the first 9 a week (10 in 2028, 11 in 2029, 12 in 2030) are paid at double and any beyond that at triple (articles 66 to 68). Optional rounding snaps each clock time to the nearest 5, 6 or 15 minutes, the increments the US Department of Labor allows when rounding averages out. Pay is gross straight-time plus overtime premium, before tax and deductions. Paid rest breaks should stay in the hours; only unpaid time comes off.
Worked example
With the defaults, an 8-hour day minus a 30-minute unpaid lunch is 7.5 paid hours; over 5 days that is 37 hours 30 minutes (37.50 decimal hours) a week, under the 40-hour overtime line. At $22 an hour, 37.5 × 22 = $825.00 a week, or $42,900 over 52 weeks. Working 9 hours a day with no break for 5 days at $9 instead gives 45 hours: 40 × $9 = $360 plus 5 overtime hours × $13.50 = $67.50, so $427.50 for the week.
Sources: US Department of Labor: Overtime pay (FLSA) · US Department of Labor: Fact Sheet #23, Overtime pay requirements · California DIR: Overtime FAQ · 29 CFR 785.48: Use of time clocks (rounding) · PROFEDET via ADN40 (2026): pay for overtime hours in Mexico · EY Law Flash: reduction of the working week in Mexico (LFT decree, DOF 1 May 2026) · Tax Today Mexico: LFT reform on reducing the working week published
Frequently asked questions
How do I calculate hours worked on a timesheet?
For each day subtract the start time from the end time, take off any unpaid break, then add the days together. 9:00 to 17:30 is 8 hours 30 minutes; minus a 30-minute lunch it is 8 paid hours, and five such days make 40 hours.
How do I convert minutes to decimal hours?
Divide the minutes by 60: 15 minutes is 0.25 h, 30 minutes is 0.5 h and 45 minutes is 0.75 h. So 37 hours 30 minutes is 37.50 on payroll, not 37.30.
When is overtime owed in the US?
Under the federal Fair Labor Standards Act, non-exempt employees earn at least 1.5 times their regular rate for hours over 40 in a workweek. Federal law has no daily overtime, but some states do: California pays 1.5× after 8 hours in a day and 2× after 12.
How does California’s seventh-day rule work?
If you work all seven days of a workweek, the first 8 hours on the seventh day are paid at 1.5× and any hours past 8 that day at 2×. The calculator applies it when every day in day-by-day mode has hours, or when days per week is 7.
How are overtime hours paid in Mexico?
Under the Ley Federal del Trabajo as reformed in May 2026, hours past the legal week are overtime: 48 hours in 2026, 46 in 2027, 44 in 2028, 42 in 2029 and 40 from 2030. The first 9 overtime hours a week (10 in 2028, 11 in 2029, 12 in 2030) are paid at double, spread over at most 4 hours a day on 4 days, and up to 4 more at triple. Pick the year of the pay period under the Mexico rule.
Should paid breaks be deducted?
No. Only unpaid time comes off. In the US, short rest breaks of 5 to 20 minutes generally count as paid work time, while a bona fide meal period of 30 minutes or more can be unpaid.
Can I enter a night shift?
Yes. In day-by-day mode, if the end time is earlier than the start (for example 22:00-6:00), the shift is counted as running past midnight, so it is 8 hours.
Related calculators
Overtime rules vary by country, state, contract and job classification (exempt or non-exempt). Check your employer’s policy and local law before relying on these figures for payroll.