Timesheet hours calculator

Paste your clock-in and clock-out lines instead of keeping a manual Excel or Google Sheets timesheet, and get daily hours and a weekly total in under 2 minutes, right in the browser. It reads both 24-hour and 12-hour times, warns you when a line runs past midnight or has the same start and end, and lists every bad line with its line number at once instead of stopping at the first one, while the good lines still add up to a total marked as a partial total. Type one line per day with start time, end time and break in minutes, and add an hourly rate if you want the amount to invoice. Everything is calculated in your browser, so your times never leave your device.

Runs in your browser; what you type never leaves your device.

Days

One day per line, 24-hour or 12-hour times (17:30 or 5:30 PM). An end earlier than the start counts as past midnight and shows a warning.

Billing

Your hours

Enter one line per day, such as 09:00 17:30 30, to see your hours.

Total hours
—
Billable amount
—
Lines left out of the total
—
Days counted
—
Hours per day
—

This is a calculation aid, not legal, payroll or tax advice; check overtime and break rules that apply to you.

How to use it

  1. Write one line per day: start time, end time and break minutes, for example 09:00 17:30 30 or 9:00 AM 5:30 PM 30.
  2. Use 24-hour or 12-hour times (9am, 5pm, 12:30 PM). A line that crosses midnight or has the same start and end shows a warning so you can check it.
  3. Optionally enter your hourly rate to get a billable amount.
  4. Read the hours for each line, the weekly total and the amount, and copy the one you need.
  5. If some lines are wrong, they are all listed together with their line numbers and the total is marked "(Partial total: N lines excluded)". Fix those lines to get the full total.

Frequently asked questions

How do I calculate hours worked with breaks?

Subtract the start time from the end time, then take off the break. For 09:00 to 17:30 with a 30-minute break, that is 8 hours 30 minutes minus 30 minutes, or 8 hours.

What if my shift goes past midnight?

When the end time is earlier than the start time, the calculator treats the end as the next day and adds 24 hours. A shift from 22:00 to 06:00 counts as 8 hours, and the page shows the warning "Day N: treated as past midnight". If the start and end are identical, such as 09:00 09:00, the line counts as 24 hours and a warning asks you to check it.

How is the weekly total rounded?

Minutes are added up first and converted to hours once, then rounded to two decimals. For example 70 minutes shows as 1.17 hours, so small rounding errors do not pile up across days.

How is the billable amount calculated?

The amount is the weekly total hours, as shown, multiplied by your hourly rate. With 11.50 hours at a rate of 45, the amount is 517.50.

Can I type 12-hour times like 9:00 AM or 5pm?

Yes. Both 24-hour times (17:30) and 12-hour times (5:30 PM, 9am, 12:30 PM) work, even mixed on one line. 12 AM is midnight and 12 PM is noon; 13pm or 0am is rejected.

Why is a line listed as an error, and what is a partial total?

A line is listed when a time is not a valid 24-hour or 12-hour time, when the break is negative or not a number, when the break is as long as the shift, or when it does not have 2 or 3 values. Every bad line is shown at once with its line number and reason, and the tool does not stop at the first one. The good lines are still added up, and the total is marked "(Partial total: N lines excluded)" so you know it is not the full sheet. A break such as -30 is rejected rather than added to your hours. If every line is bad, you see an empty-state message with the reasons instead of a total.

Version 0.1.0 · Updated 2026-11-13