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.
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.
- Monday 8.00 hours
- Tuesday 7.75 hours
- Wednesday 8.50 hours
- Thursday 8.00 hours
- Friday 6.25 hours
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.
Paid versus unpaid breaks
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
- Mixing formats: Combining 12-hour and 24-hour times in one calculation leads to 12-hour errors.
- Forgetting the break: A missed 30-minute break overstates every day by half an hour.
- Adding minutes as decimals: 1.45 hours is not 1 hour 45 minutes. It is 1 hour 27 minutes.
- Rounding too early: Round the weekly total, not each small entry, unless your policy says otherwise.
- Ignoring time zones: Remote workers should log times in one agreed time zone.
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.