Timesheet Calculator

Turn your clock records into worked hours

A clock record showing 9:00 AM to 5:30 PM covers eight and a half hours, but that may not be the time you should total for work. If the record includes a 45-minute unpaid lunch, the worked time is seven hours and 45 minutes. Keeping those two quantities separate makes the weekly total easier to check.

This timesheet calculator adds the net hours from your daily records. Use it to check a paper timesheet, prepare hours for an invoice, or compare your own total with an attendance report. The optional pay estimate applies the rate and overtime convention you choose. It does not determine which hours an employer must pay or what your take-home pay will be.

Enter a week you can check against your records

1. 1. Choose the period and days

   Weekly shows one week; Biweekly shows two. Select All 7 days if you worked a weekend, and use Add week for a longer record. The Start of week setting changes the order when weekends are visible.

2. 2. Copy the actual clock times

   Enter Time in and Time out for each worked day. The time control follows your browser’s format, which may show AM/PM or a 24-hour clock. Enter unpaid breaks in minutes and leave unused days completely blank.

3. 3. Review the net hours and total

   Results update as you enter valid records. Calculate takes you to the total, or to the first field that needs correction. Open the optional settings only if you need an overtime split or a pay estimate.

Check morning and afternoon values before accepting an unusually long row. An earlier Time out is treated as the following day. That supports night shifts, but it also means an accidental 5:00 AM instead of 5:00 PM can create a plausible-looking overnight result.

Changing Days to show or the period keeps hidden entries for later. Hidden rows do not contribute to the current result. Clear times removes all time and break entries, including hidden ones, while keeping your settings. Reset also restores one weekday week, breaks enabled and no overtime or pay estimate. Remove week deletes the selected week.

Worked example: a week with an unpaid lunch

Consider this illustrative Monday–Friday record with the same hours each day. Choose None under Overtime calculation for this first example. The clock times show the whole interval at work; the break entry tells the calculator how much of that interval to leave out.

Scroll the table to see every column.

First find the clock span: eight hours and 30 minutes is 510 minutes. Subtract the unpaid break once, then add the net minutes for the five days. This order prevents an already-deducted lunch from being removed again when you calculate the weekly total.

If your illustrative hourly rate is 40 USD, enabling Include pay estimate gives 38.75 × 40 = 1,550 USD before deductions. Replace that rate with your own. The displayed example rate is not a suggested wage, and the estimate does not include tax, benefits, expenses or additional premiums.

The estimate answers what these recorded hours amount to at the chosen rate. Before passing it on, compare one day with the original clock record, then check that all five days belong in this pay period.

Read the total without losing the daily detail

Start with Total worked time, then inspect the supporting values if something differs from your own record. Regular time and Overtime divide the worked minutes; they are not extra hours to add on top of Total worked time. With overtime set to None, all worked minutes are regular time.

Scroll the table to see every column.

The weekly breakdown appears when more than one week is visible. Open Worked hours by day to spot a short day or an unexpectedly long shift. The chart compares the entered durations; the exact time beside each bar remains the value to verify. An empty day contributes nothing, so a missing record cannot be discovered from the total alone.

Why 7 hours 45 minutes is 7.75 hours

Minutes use a base of 60. To convert minutes to decimal hours, divide them by 60, then add the complete hours.

The calculator totals whole minutes before converting to decimal hours. Decimal hours display to two places, but pay uses the underlying minutes rather than the rounded display. One minute therefore displays as 0.02 hours while its pay calculation still uses exactly one sixtieth of an hour. There is no automatic rounding to five, six or fifteen minutes.

Gross pay displays to two decimal places in USD. Separate displayed regular and overtime amounts can differ by a cent from their displayed sum because the combined estimate is rounded after adding the unrounded amounts. Currency conversion and other currency-specific rounding rules are outside this sheet.

Choose daily or weekly overtime deliberately

The two overtime options answer different questions. The 8h / day option treats the portion above eight net worked hours in each row as overtime. The 40h / week option compares the sum of that week’s net hours with forty. Only one option applies at a time; the calculator does not combine daily and weekly rules.

For a second illustrative week, enter 9:00 AM to 6:00 PM with a 30-minute unpaid break on each of five days. Each day contributes eight hours and 30 minutes, giving 42 hours and 30 minutes overall. Either threshold happens to give 40 regular hours and two hours and 30 minutes of overtime in this particular example.

A 1.5 multiplier means the overtime hour receives 150% of the entered rate in this model. It is not a further 150% added to an already-paid regular hour. The regular time excludes the overtime minutes, so those minutes are counted once in the combined estimate.

To see why the choice matters, keep the same weekly record while changing only the overtime option. One ten-hour day followed by four seven-hour days totals 38 net hours. The long day exceeds the daily threshold even though the whole week stays below the weekly threshold.

Scroll the table to see every column.

Choose the setting that matches the calculation you are checking, and confirm actual payroll treatment with the applicable agreement or payroll process. A result under one of these settings does not establish which convention applies to your work.

For biweekly sheets, each week is assessed separately. A 45-hour first week and a 35-hour second week produce five weekly overtime hours and 75 regular hours. Averaging them into two 40-hour weeks would hide those five hours. Each row belongs to its displayed week, including an overnight shift that ends in the next calendar week.

Breaks, night shifts and days without work

Enter only the unpaid time you want deducted. A 30-minute paid break should not also be subtracted from the shift. If a day contains more than one unpaid break, add those break lengths before entering the single Break (min) value. Turning off Deduct unpaid breaks ignores all break entries without erasing them.

A night shift from 10:00 PM to 6:00 AM spans eight clock hours. With a 30-minute unpaid break, its net time is seven hours and 30 minutes. The row shows Ends next day so you can check the interpretation. Equal times mean a zero-length interval; a full 24-hour shift needs a different recording method.

An unused row is different from a worked row that totals zero. Leave both times and the break blank for a day off. Entering only one clock time needs correction. A break longer than the shift is rejected instead of producing negative hours, and a break equal to the shift produces a valid zero.

Review the record before sharing the total

A timesheet records when work took place; the total alone cannot explain which tasks were completed. Keep the dates, project notes and original clock records alongside the calculated hours. That lets an employee explain a discrepancy and lets a manager or client check which work period a number belongs to.

For project planning, compare recorded hours with the work actually delivered before treating a long day as low productivity or using it to estimate the next job. Travel, training, interruptions and different task difficulty can change that comparison. This calculator does not collect those details or assign hours to individual projects.

• Match each visible week to the correct period in your original record, including the chosen start of week.
• Check AM/PM and every Ends next day note, especially on a row much longer than its neighbors.
• Verify that breaks were unpaid and have not already been removed from the recorded interval.
• Confirm the rate, overtime option and multiplier before using an estimated amount.
• Keep your own copy of the source records. Reloading this page clears the entries; it is not an attendance database.