Hours & Timesheet Calculator

Hours Calculator turns start and finish times into the numbers you actually need: total hours worked, the same total in decimal hours for payroll, overtime and the pay it adds up to. Type each day’s start, finish and unpaid break, and the totals update as you go. A finish earlier than the start, such as 22:00 to 06:30, is treated as a night shift that runs past midnight, so it is never counted as negative time.

It suits casual and shift workers checking a payslip, freelancers billing by the hour, carers and nurses on nights, and managers putting a weekly timesheet together. When you are done, copy the whole timesheet as a table that pastes straight into Excel, Google Sheets or Numbers, or download it as a CSV file.

Two smaller calculators sit beside the timesheet. “Add times” adds and subtracts durations like 3:45 + 2:30 − 0:50, a column of times or 7:30 × 5. “Time between” finds the gap between two clock times or what time it will be after a duration. Switch between 24-hour and 12-hour clocks at any time. Your rows are saved only in this browser.

1. In “Timesheet”, type a start, finish and break for each row. Times like 9, 930, 9:30 or 5pm all work, and a plain break number means minutes.
2. Use “Add row” for more days, “Copy first row down” to repeat a regular shift, or “New week (Mon–Sun)” to start a fresh week with dates.
3. Optionally add an hourly rate, pick a currency and choose an overtime rule: after a number of hours per day or in total, at × 1.25, × 1.5 or × 2.
4. Read the total in hours and minutes, decimal hours, overtime and pay.
5. Press “Copy as table” to paste into a spreadsheet, or “Download CSV”. For quick sums, open “Add times” or “Time between”.

• Timesheet rows with start, finish and unpaid break, and a running total per row.
• Night shifts across midnight handled automatically and marked “+1 day”.
• Totals in hours and minutes (h:mm) and decimal hours to two places.
• Optional hourly rate in $, £, €, ₹, ¥, R, kr or CHF, with the symbol picked from your language setting.
• Overtime after a set number of hours per day or across all rows, paid at × 1.25, × 1.5, × 2 or the normal rate.
• Copy as a tab-separated table for spreadsheets, or download a CSV with totals, overtime and pay.
• Add and subtract durations with seconds, unit words (2h 15m, 90m) and × or ÷ by a number.
• Time between two clock times, and a clock time plus or minus a duration, with next-day and day-before notes.
• A 24-hour or 12-hour clock, and rows remembered on this device.

• Payroll usually wants decimal hours: 7 hours 45 minutes is 7.75, not 7.45. Copy the decimal column, not the h:mm one.
• Breaks are unpaid time taken off the shift. If your break is paid, leave the break box empty.
• For a shift of 24 hours or more, split it into two rows. A row with the same start and finish time is flagged rather than guessed.
• Press Enter in any box to jump to the next row; at the bottom it adds a new one.
• Overtime rules differ by award, contract and country. This tool applies the simple rule you choose and is not legal or payroll advice.