Calculators

How to Add Up Hours and Minutes for Timesheets and Payroll

Time does not add like normal numbers – 60 minutes make an hour, not 100. Here is how to total shifts correctly and turn them into hours you can pay.

In this article
  1. Why time arithmetic trips people up
  2. Minutes to decimal hours
  3. How to use the Time Calculator
  4. Shifts with start and end times
  5. A weekly timesheet example
  6. Overtime
  7. Rounding time
  8. Timesheets in spreadsheets
  9. Other uses

Why time arithmetic trips people up

Calculators and spreadsheets treat 8.30 as eight and three tenths. But 8:30 on a timesheet means eight and a half hours. Adding 7:45 and 8:30 as decimals gives 16.15, while the real total is 16 hours 15 minutes – which is 16.25 hours for pay. Mixing the two systems is the most common payroll mistake.

Time CalculatorAdd and subtract hours, minutes and seconds, or find the time between two clock times including overnight shifts and breaks. Decimal hours included.
Open the free tool

Minutes to decimal hours

MinutesDecimal hours
60.1
150.25
200.333
300.5
400.667
450.75

Formula: decimal hours = hours + minutes ÷ 60. So 8:30 × a pay rate of 1,200 per hour = 8.5 × 1,200 = 10,200.

How to use the Time Calculator

  1. Open the Time Calculator.
  2. Enter durations in any format: 1:30, 1:30:15, 90 (minutes) or 2h 15m.
  3. Add or subtract as many as you need – a whole week of shifts, minus breaks.
  4. Read the total in hours and minutes and in decimal hours.

Shifts with start and end times

For a shift from 09:15 to 17:45 with a 30-minute break: 17:45 − 09:15 = 8:30, minus 0:30 = 8:00 hours. Overnight shifts – for example 22:00 to 06:00 – cross midnight; the calculator handles this automatically, giving 8 hours rather than a negative number.

A weekly timesheet example

DayHours
Monday8:15
Tuesday7:50
Wednesday8:30
Thursday9:05
Friday6:40
Total40:20 = 40.33 hours

Overtime

If overtime starts after 40 hours a week, the 0:20 above (0.33 hours) is paid at the overtime rate. Rules on overtime, breaks and rounding differ by country and employer, so follow your contract and local labour law.

Rounding time

Some employers round to the nearest 5, 6 or 15 minutes. Decide on one rule, apply it consistently, and round each entry before adding – or the total, if that is your policy. For invoicing clients, many freelancers bill in 6-minute (0.1 hour) units.

Timesheets in spreadsheets

If you track hours in Excel or Google Sheets, store times as real time values and format the total cell as [h]:mm – the square brackets stop totals over 24 hours from wrapping back to zero. To convert a time total in A1 to decimal hours for pay, multiply by 24: =A1*24. Check a few rows against the Time Calculator the first time you set the sheet up.

Other uses

  • Total the length of video clips or songs for a playlist.
  • Plan a day: add up meeting and travel times.
  • Training logs: total running or study time for the week.

For counting calendar days instead of hours, use the Date Calculator; for averages of times, convert to decimal and use the Average Calculator.

Time CalculatorAdd and subtract hours, minutes and seconds, or find the time between two clock times including overnight shifts and breaks. Decimal hours included.
Open the free tool
Keep reading

Related articles

All articles
Calc

How to Count Days Between Dates for Deadlines and Notice Periods

“Within 30 days”, “10 working days”, “one month’s notice” – simple phrases that cause real arguments. Here is how to count dates correctly.

3 min read
Calc

How to Calculate Your Exact Age for Forms, Exams and Eligibility

Job adverts, exam boards and visa forms often ask for your age “as on” a specific date. Getting it exactly right can decide whether you are eligible.

3 min read
Calc

Unit Conversions That Confuse Everyone – Gallons, Cups, Megabytes and More

Some units have the same name but different sizes depending on the country or context. Here are the traps, with exact numbers to rely on.

3 min read