What the Timesheet Hours Calculator does
This timesheet calculator adds up a week of clock-in and clock-out times, takes off unpaid breaks, handles shifts that run past midnight, applies the rounding rule you choose, and splits the total into regular hours, overtime and double time. Enter an hourly rate and it also shows gross pay. Results are given both as hours and minutes and as decimal hours, which is what most payroll systems want.
The overtime rules are yours to set - weekly, daily or both - because they depend on country, state and contract. The default of overtime after 40 hours a week is the US federal Fair Labor Standards Act rule for non-exempt employees; other places and agreements use different thresholds.
How to use it
- Type the start and end time for each day you worked, and the unpaid break in minutes. Leave both times empty for a day off.
- For a night shift, enter the real times - for example 22:00 to 06:00. An end time earlier than the start is counted into the next morning.
- Set the overtime rules: hours per week after which overtime starts, and optionally a daily threshold and a daily double-time threshold.
- Choose a rounding rule if your employer rounds punches, and enter an hourly rate and multipliers if you want gross pay.
- Check the day-by-day table, then copy the summary, download a CSV for payroll, or print the week.
Reading the results
Worked time is the span from start to end minus the unpaid break. Paid breaks should not be entered as breaks.
Daily overtime is counted first. Weekly overtime then applies only to hours still counted as regular, taken from the last days worked, so no hour is ever paid as overtime twice.
Decimal hours are minutes divided by 60: 7 hours 45 minutes is 7.75, not 7.45. Payroll errors often come from mixing the two.
Worked example: a week with a night shift
Monday 09:00-17:30 with a 30-minute break is 8 hours. Tuesday night 22:00-06:00 with 30 minutes' break is 7.5 hours. Wednesday is off. Thursday 08:00-20:00 with an hour's break is 11 hours, Friday 09:00-18:00 with an hour is 8 hours, and Saturday 10:00-16:00 with no break is 6 hours.
That is 40.5 hours. With overtime after 40 hours a week, the last 30 minutes - on Saturday - become overtime. At 20 an hour and time and a half, pay is 40 x 20 + 0.5 x 30 = 815.
With a daily rule of overtime after 8 hours instead, Thursday's extra 3 hours are overtime and the remaining 37.5 regular hours are below the weekly threshold, so no further overtime applies. The calculator also flags Saturday: six hours without a break.
Formulas and scoring rules
- Worked time
worked = (end - start, adding 24 h if end < start) - unpaid break- Daily split
double = max(0, worked - double-time threshold); overtime = max(0, worked - daily threshold - double)- Weekly overtime
weekly OT = max(0, sum of regular - weekly threshold), moved from the last days worked- Rounding
round(minutes / step) x step, or up / downApplied to each punch or to each day's total, as you choose.- Gross pay
rate x (regular + overtime x OT multiplier + double x DT multiplier)Hours are shown to two decimals; pay to two decimals.
Rounding and the law
Many employers round clock times to the nearest 5, 6 or 15 minutes. In the US, the Department of Labor accepts this only when it averages out so employees are paid for all the time they actually work (29 CFR 785.48); always rounding in the employer's favour is not allowed. Other countries have their own rules, and many simply require paying the actual time.
Limitations: what the result does not prove
- It does not decide which overtime rules apply to you. Exempt status, state laws, collective agreements and contracts all change the answer; set the thresholds to match your situation.
- Gross pay excludes tax, deductions, shift premiums, tips and allowances.
- A week is treated as the seven rows shown. If your pay week starts on another day, enter the days in your pay week's order.
- It does not know whether a break was genuinely unpaid and uninterrupted; enter only breaks that are unpaid.
Privacy: where your data goes
Everything you paste, type or drop is processed in this browser tab. It is not uploaded, logged, stored or sent to analytics. Session recording and tag-manager scripts are switched off on this page.
Standards and sources
- US Department of Labor - Fair Labor Standards Act hours worked (Fact Sheet 22) - checked 19 Sep 2026
- eCFR - 29 CFR 785.48 Use of time clocks
- US Department of Labor - Overtime pay
Frequently asked questions
How do I calculate hours worked on a night shift that crosses midnight?
Enter the real start and end times, such as 22:00 and 06:00. Because the end is earlier than the start, the calculator adds 24 hours to the end before subtracting, giving 8 hours, then takes off the unpaid break.
How do I convert hours and minutes to decimal hours?
Divide the minutes by 60 and add them to the hours. 7 hours 45 minutes is 7 + 45/60 = 7.75 decimal hours; 8 hours 20 minutes is 8.33. The table shows both forms so you can copy the one payroll needs.
When does overtime start?
Under the US federal FLSA, non-exempt employees earn overtime after 40 hours in a workweek. Some states, such as California, also have daily overtime and double time. Elsewhere it depends on national law and your contract, so set the thresholds to your rule.
Is it legal for my employer to round my clock-in time?
In the US it is allowed if the rounding is neutral over time, so employees are not undercompensated. Rounding that always favours the employer is not. Rules differ in other countries; if in doubt, compare rounded and exact totals with this calculator.
Should lunch breaks be deducted from my hours?
Deduct only unpaid breaks. In the US, bona fide meal periods of typically 30 minutes or more when you are fully relieved of duty can be unpaid, while short rest breaks are counted as work time. Enter only the unpaid part.
How are daily and weekly overtime combined without double counting?
The calculator first moves hours over the daily threshold into overtime. It then totals the remaining regular hours and, if they exceed the weekly threshold, moves the excess into overtime starting from the last day worked. Each hour is counted once.
Last reviewed by the A2Z.Tools team against the sources listed above.
