To calculate timesheet hours with lunch breaks, subtract the unpaid break minutes from the gross time between clock-in and clock-out for each day, then sum the daily net hours across the week. The formula in minutes is (clock-out − clock-in) − break minutes, divided by 60 to convert back to decimal hours. For example, working 09:00 to 17:00 with a 30-minute lunch yields (480 − 30) ÷ 60 = 7.50 net hours for that day. Repeating this for every workday in the week gives the total net hours. The Timesheet Calculator performs this calculation automatically for all seven days at once and displays each day's net hours rounded to two decimals, so you can copy the weekly total directly into payroll or your invoice. You never have to write the formula by hand or build a spreadsheet — the tool handles 24-hour time conversion, break subtraction, and overnight shifts behind the scenes, while everything runs locally in your browser so your timesheet data stays private. Every value you type updates the totals immediately, so you can tweak break lengths or schedules and watch the net hours change in real time.
What "Lunch Deduction" Means in a Timesheet
An unpaid lunch break is time you spend away from work that your employer doesn't count toward paid hours. If you clock in at 09:00, take an hour for lunch, and clock out at 18:00, the raw time between clock-in and clock-out is 9 hours, but only 8 of those are actually worked. The 1-hour lunch needs to come out of the total before it counts toward your weekly hours, your overtime threshold, or your paycheck.
This matters because most payroll systems, hourly invoices, and overtime regulations all define a paid hour as time actually worked, not time physically on the premises. Whether your lunch break is 15 minutes, 30 minutes, or 60 minutes, the math is the same: subtract the break minutes from the shift length in minutes, then divide by 60. Doing this for every day and adding the results gives the net hours for the week.
Some workplaces use a different convention — paid lunch breaks — where the lunch is counted as worked time and nothing needs to be deducted. If that describes your situation, you can simply enter 0 in the break field for each day and the timesheet totals will be identical to the raw clock-in to clock-out span.
Enter Your Week in the Timesheet Calculator
The Timesheet Calculator gives you one row for every day from Monday through Sunday. Each row takes three inputs: the time you started work, the time you finished, and how many minutes of unpaid break you took. The tool uses a standard 24-hour clock, so 9 in the morning is 09:00, noon is 12:00, and 5 in the afternoon is 17:00.
| 12-hour clock | 24-hour entry |
|---|---|
| 12:00 AM (midnight) | 00:00 |
| 9:00 AM | 09:00 |
| 12:00 PM (noon) | 12:00 |
| 1:30 PM | 13:30 |
| 5:00 PM | 17:00 |
| 10:00 PM | 22:00 |
As soon as you fill in a day, the calculator works out that day's net hours and shows the result, rounded to two decimal places, beside the row. Blank days are simply skipped, so you never have to zero anything out or delete rows you don't need. Underneath the daily rows, a running weekly total keeps a live count of every hour worked across the seven days.
How to Calculate Timesheet Hours With Lunch
- Type your clock-in time for Monday in 24-hour format (for example, 08:30).
- Type your clock-out time for Monday in the same row (for example, 17:00).
- Enter the unpaid lunch break in minutes — 30, 45, 60, or whatever your schedule requires.
- Read the daily net hours shown beside Monday's row and the running total below the table.
- Repeat the same three inputs for Tuesday, Wednesday, Thursday, and Friday (or whichever days you actually worked).
- Leave Saturday and Sunday blank if you didn't work — the calculator skips them automatically.
- Check the weekly total at the bottom of the table to confirm the net hours for the whole week.
Worked example
Suppose you work Monday through Friday, 09:00 to 17:00 each day, with a 30-minute unpaid lunch. The daily calculation in minutes is (17 × 60 − 9 × 60) − 30 = (1020 − 540) − 30 = 480 − 30 = 450 minutes, which is 450 ÷ 60 = 7.50 hours per day. The weekly total is 5 × 7.50 = 37.50 hours. Enter these five rows in the calculator and it will show 7.50 beside each row and 37.50 in the weekly total, with no manual arithmetic required.
How Overnight Shifts and Break Edge Cases Are Handled
If your clock-out time is earlier than your clock-in time, the calculator assumes you finished the next morning. A 22:00 start with a 06:00 finish comes out as a full 8.00 hours rather than a negative number, which is exactly what shift workers, hospitality staff, nurses, security guards, and anyone on a night rotation need. Identical clock-in and clock-out times are counted as zero hours — useful if you accidentally entered the same value in both fields.
For break lengths, the calculator subtracts your unpaid break minutes from each day's gross hours before adding the day up. If a break is longer than the shift itself, that day is clamped to zero rather than dipping into a negative value. So if you only worked four hours but accidentally entered a five-hour break, the row shows 0.00 hours instead of −1.00, and the weekly total stays clean.
Adding an Hourly Rate and an Optional Overtime Rule
If you also want a pay estimate, add an hourly rate and pick a currency symbol; the calculator multiplies your total hours by your rate and shows the amount with proper thousands separators and two decimal places. Pay is entirely optional — leave the rate blank and the tool stays a pure hours calculator. For the example above, an hourly rate of 18.50 with five days at 7.50 net hours gives 37.50 × 18.50 = 693.75 in the weekly pay field.
For people who want a quick overtime estimate, there is an optional rule you control yourself. You decide the weekly threshold in hours and the multiplier that applies above it, with a common starting point of 40 hours at 1.5 times pre-filled but switched off by default. When the rule is on, hours up to your threshold are paid at the base rate and the hours beyond it are paid at your chosen multiple. This is deliberately kept as simple convenience math and is not legal or payroll advice — overtime rules differ by country, state, and contract, so always confirm the numbers against the rules that apply where you work.
Change any value — a clock-in time, a break length, a rate — and the daily hours, weekly total, and pay recalculate instantly in your browser. You can experiment with different schedules, break lengths, and rates until the numbers match what you expect, without reloading or losing your work.
Who the Timesheet Calculator Is Built For
| User type | What they need | How the calculator helps |
|---|---|---|
| Hourly employee | Confirm hours on a pay stub | Recreates the week from clock-in, clock-out, and break minutes |
| Freelancer | Billable hours for an invoice | Returns two-decimal daily totals and a weekly figure ready to copy |
| Small business owner | Prepare payroll | Multiplies hours by an hourly rate and currency of your choice |
| Manager | Verify a rota or schedule | Lets you adjust shifts and breaks to see the weekly impact immediately |
| Shift worker | Overnight or split-shift accuracy | Auto-detects when clock-out is earlier than clock-in and rolls to the next day |
Everything runs locally in your browser using plain JavaScript. Your times, breaks, and rate figures are never sent to a server, never stored, and never shared, which makes the tool safe to use with real work data. If you need to convert the resulting decimal hours into hours, minutes, and seconds for a different report, the decimal-to-time conversion guide walks through that format step by step.
Adjust any time, break, or rate and the daily hours, weekly total, and pay recalculate in your browser, so you can experiment with different schedules until the numbers match what you expect.