💼 Money & Careers

How to Calculate Hours Worked on a Timesheet: Breaks, Overnight Shifts and Decimals

6 min readPublished Nov 21, 2026Updated Nov 21, 2026
In this article
  1. The basic method
  2. Converting minutes to decimal hours
  3. Overnight shifts that cross midnight
  4. Adding up a weekly total
  5. Paid versus unpaid breaks
  6. Turning hours into pay or an invoice
  7. Common timesheet mistakes
  8. Tips for accurate timesheets
  9. Frequently asked questions

Whether you are filling in a weekly timesheet, invoicing a client or checking your paycheck, the maths is the same: end time minus start time, minus unpaid breaks. The mistakes happen in the details, so here is a clear method with worked examples.

The basic method

To find hours worked in a day, subtract the start time from the end time, then subtract any unpaid break. Work in 24-hour time if you can, because it removes the AM and PM confusion.

hours worked = (end time - start time) - unpaid break

Example: you clock in at 9:00 and clock out at 17:30 with a 30-minute unpaid lunch. From 9:00 to 17:30 is 8 hours 30 minutes. Subtract 30 minutes and you have 8 hours worked.

Converting minutes to decimal hours

Payroll and invoices usually need decimal hours, not hours and minutes. Divide the minutes by 60 and add them to the whole hours. So 7 hours 45 minutes is 7 + 45/60 = 7.75 hours, and 6 hours 20 minutes is 6.33 hours.

A quick reference: 15 minutes is 0.25, 30 minutes is 0.50, 45 minutes is 0.75 and 10 minutes is about 0.17. Rounding every entry to the nearest quarter hour is common, but check whether your employer or contract allows it.

Overnight shifts that cross midnight

If a shift ends after midnight, the end time looks smaller than the start time, which breaks a simple subtraction. The fix is to add 24 hours to the end time before you subtract.

Example: a shift from 22:00 to 06:30 becomes 22:00 to 30:30. That is 8.5 hours, and with a 30-minute unpaid break the total is 8 hours. Remember to record the shift against the day it started if your payroll week rule requires it.

Adding up a weekly total

Convert every day to decimal hours first, then add them. Adding hours-and-minutes values directly is the most common error, because 1 hour 45 minutes plus 1 hour 30 minutes is 3 hours 15 minutes, not 2.75 or 3.15.

The week comes to 38.5 hours. If you are paid 20 an hour, gross pay is 770 before tax. Anything over your contracted or legal weekly limit may count as overtime, which our guide on how overtime pay works explains in detail.

A paid break stays in your hours; an unpaid break comes out. Rules differ by country, state and contract, so check your employment agreement rather than assuming. Short rest breaks are often paid, while meal breaks of 30 minutes or more are often unpaid. If you are required to stay at your desk or answer calls, the break may legally count as working time.

Turning hours into pay or an invoice

Multiply decimal hours by your rate. Employees can use the Overtime Pay Calculator when extra hours are paid at a higher multiplier. Freelancers can build a day or project price with the Day Rate Calculator and then send a professional bill with the Invoice Generator. If you only know a yearly salary, use the Salary to Hourly Calculator or read how to convert salary to hourly wage.

Common timesheet mistakes

Tips for accurate timesheets

Record start and end times as they happen instead of at the end of the week, keep a note of project names for billing, and compare your total with the hours on your payslip every pay period. Small differences are easy to fix when you catch them early, and a clear record protects you in a pay dispute.

Frequently asked questions

How do I calculate hours worked between two times?

Subtract the start time from the end time, then subtract any unpaid break. For example, 9:00 to 17:30 with a 30-minute break is 8 hours.

How do I calculate hours worked for a shift past midnight?

Add 24 hours to the end time before subtracting. A shift from 22:00 to 06:30 becomes 22:00 to 30:30, which is 8.5 hours before any break.

How do I convert 7 hours 45 minutes to decimal hours?

Divide the minutes by 60 and add the whole hours: 45 / 60 = 0.75, so the total is 7.75 hours.

Are lunch breaks included in hours worked?

It depends on your contract and local law. Paid breaks count as working time and unpaid meal breaks are subtracted.

Should I round my hours to the nearest quarter hour?

Only if your employer or client agreement allows it. When in doubt, record exact minutes and round the weekly total at most.

🧮 Open the Hours Worked Calculator and total your timesheet in seconds.

TV

ToolsViral Editorial Team
We build free calculators and write plain-English guides. Figures are examples for education; verify rates and rules for your situation.

Keep reading

Related articles