Blog Productivity How to calculate hours worked on a time card

Productivity · Nov 16, 2026

How to calculate hours worked on a time card

Calculate hours worked from a time card: subtract start from end, remove unpaid breaks, convert minutes to decimals, and total the week. Examples included.

How do you calculate hours worked on a time card?

Subtract the start time from the end time, then subtract unpaid breaks. Convert the result to decimal hours if your payroll or invoice uses decimals. Hours worked equal end time minus start time minus unpaid break.

What are the steps?

  1. Write down start and end, such as 08:45 and 17:30.
  2. Subtract. 17:30 minus 08:45 is 8 hours 45 minutes.
  3. Subtract the unpaid break. 8:45 minus 0:30 is 8 hours 15 minutes.
  4. Convert minutes to decimals by dividing by 60. 15 / 60 = 0.25, so 8.25 hours.
  5. Add the days. Five days of 8.25 hours is 41.25 hours.

How do you convert minutes to decimal hours?

Divide the minutes by 60. This table lists the common values.

MinutesDecimal hours
60.10
150.25
200.33
300.50
450.75

How do you calculate shifts that cross midnight?

Add 24 hours to the end time when the end is earlier than the start. For a start of 22:00 and an end of 06:00, 30:00 minus 22:00 is 8 hours. In a spreadsheet, use =MOD(End-Start,1)*24. The Excel steps are in minutes to decimal hours and overnight shifts.

Can you round the time?

It depends on your country, contract and payroll rules. Rounding is a legal question in many places, so check the rules that apply to you before using it for pay.

Can you skip the arithmetic?

Yes. An automatic tracker such as TimeUno records start, end and idle time for you, so there is nothing to add up by hand. It exports CSV and PDF timesheets. It has no payroll or invoicing features. The trial lasts 14 days, and there is no free tier. Individual is $9.99 a month as of November 2026. See pricing. The timesheet calculator also does the sums.

FAQ

How do I calculate hours worked with a lunch break?

Subtract the unpaid break from the span between start and end. 08:45 to 17:30 with a 30 minute break is 8.25 hours.

How do I convert 8 hours 15 minutes to decimal?

Divide 15 by 60 to get 0.25, so the result is 8.25 hours.

How do I calculate an overnight shift?

Add 24 hours to the end time. A shift from 22:00 to 06:00 is 8 hours.

Can I round to the nearest quarter hour?

Check your local rules and contract first. Rounding for pay is regulated in many places.