This free hours worked calculator totals a full week's timesheet from your clock-in and clock-out times. Enter each day's start and end, deduct unpaid breaks, choose a rounding rule if your employer uses one, and get the weekly total in both hours-and-minutes and decimal hours — plus gross pay if you add a rate.
Built by Anchor AI Tools, it works as a time card calculator for payroll, a work hours calculator for freelancers billing clients, and a quick way for employees to check their own hours against a pay stub.
Quick Answer: To calculate hours worked, convert the clock-in and clock-out times to a 24-hour format, subtract the start from the end to get the time on the clock, then subtract any unpaid break. For example, 9:00 to 17:30 with a 30-minute lunch is 8.5 hours on the clock minus 0.5 = 8 hours worked. Add each day for the weekly total, then multiply the decimal hours by your hourly rate for gross pay.
Enter clock-in and clock-out times for each day you worked, plus any unpaid break in minutes. Leave blank days empty. Add an hourly rate for gross pay, then click Calculate.
24-hour or AM/PM time pickers. Break is in minutes and is unpaid.
| Day | Clock In | Clock Out | Break (min) | Total |
|---|
Need to convert a single value instead? Use the time to decimal calculator, the hours to decimal calculator, or read the result back as clock time with decimal to time.
Hours Worked = (Clock Out − Clock In) − Unpaid Break
Each day is totalled, then summed for the weekThe calculator converts each clock time to minutes since midnight, subtracts clock-in from clock-out to find the time on the clock, then subtracts the unpaid break. If a shift crosses midnight (clock-out earlier than clock-in), it adds 24 hours so an overnight shift totals correctly. Each day's minutes are added for the week, then converted to decimal hours by dividing by 60.
Many employers round clock times to a set interval. Under the U.S. Department of Labor's interpretation of the Fair Labor Standards Act, time may be rounded to the nearest 5 minutes, the nearest tenth of an hour (6 minutes), or the nearest quarter hour (15 minutes), provided the rounding does not consistently favour the employer.
The best-known method is the 7-minute rule for quarter-hour rounding: time from 1 to 7 minutes past an interval rounds down, and time from 8 to 14 minutes rounds up to the next quarter hour. So a punch at 8:07 is treated as 8:00, while 8:08 becomes 8:15. The calculator above applies your chosen rounding to each clock-in and clock-out before totalling.
| Rounding | Interval | Example punch | Rounds to |
|---|---|---|---|
| Nearest 15 min | 1/4 hour | 8:07 | 8:00 |
| Nearest 15 min | 1/4 hour | 8:08 | 8:15 |
| Nearest 6 min | 1/10 hour | 8:04 | 8:06 |
| Nearest 5 min | 5 minutes | 8:07 | 8:05 |
📋 A standard work week at $25/hour
Each day is 9:00 to 17:30 with a 30-minute unpaid lunch — that is 8.5 hours on the clock minus 0.5 = 8.00 hours worked per day, across five days.
| Day | In | Out | Break | Worked |
|---|---|---|---|---|
| Monday | 9:00 | 17:30 | 30 min | 8.00 |
| Tuesday | 9:00 | 17:45 | 30 min | 8.25 |
| Wednesday | 9:00 | 17:30 | 30 min | 8.00 |
| Thursday | 9:00 | 18:00 | 30 min | 8.50 |
| Friday | 9:00 | 16:50 | 30 min | 7.33 |
| Total | — | — | — | 40.08 |
The week totals 40.08 decimal hours (displayed rounded). Using the exact value for pay, 40.0833 × $25 = $1,002.08 gross. Entering the times wrong as plain clock numbers would miscount the partial hours on Tuesday and Friday.
An hours worked calculator totals each day, deducts breaks, and gives the weekly decimal hours for payroll.
With clock-in in cell A2 and clock-out in B2, both stored as time values, subtract and multiply by 24 for decimal hours, then subtract the break:
Format the daily cells as Number with two decimals, not Time. For overnight shifts where clock-out is the next day, add 1 before multiplying: =((B2 - A2 + 1) * 24). To convert any single value, use the minutes to decimal converter.
This time card calculator is used by hourly employees checking their pay, freelancers and contractors totalling billable hours for invoices, small business owners running weekly payroll, HR teams processing timesheets, and managers approving hours before submitting them. Anyone who tracks clock-in and clock-out times and needs an accurate weekly total in decimal hours can use it.
For the full payroll process including overtime rules, read our guide to converting time to decimal for payroll. To work out deductions on the gross figure, use the percentage calculator.
Need to convert a single clock time to decimal?
Use the Time to Decimal Calculator →=((B2-A2)*24)-(C2/60) where A2 is clock-in, B2 is clock-out, and C2 is break minutes. Format the cell as Number, not Time.Time to Decimal Calculator
Convert a clock time to decimal hours.
Hours to Decimal
Convert hours and minutes for payroll.
Minutes to Decimal
Convert minutes to decimal with a full chart.
Decimal to Time
Convert decimal hours back to clock time.
Payroll Conversion Guide
Full how-to with overtime examples.
Percentage Calculator
Calculate deductions, tax, and discounts.
Published by Anchor AI Tools · © 2026 Anchor AI Tools