In this article
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.
Minutes to decimal hours
| Minutes | Decimal hours |
|---|---|
| 6 | 0.1 |
| 15 | 0.25 |
| 20 | 0.333 |
| 30 | 0.5 |
| 40 | 0.667 |
| 45 | 0.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
- Open the Time Calculator.
- Enter durations in any format:
1:30,1:30:15,90(minutes) or2h 15m. - Add or subtract as many as you need – a whole week of shifts, minus breaks.
- 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
| Day | Hours |
|---|---|
| Monday | 8:15 |
| Tuesday | 7:50 |
| Wednesday | 8:30 |
| Thursday | 9:05 |
| Friday | 6:40 |
| Total | 40: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.