How to Convert Minutes to Decimal Hours for Your Timesheet
If you've ever filled in a timesheet that wants "hours worked" as a single number, you've probably stopped at something like 7 hours 45 minutes and wondered what to type. It's 7.75, not 7.45, and that one mix-up is behind a surprising number of short paychecks and wrong invoices.
Why timesheets want decimals in the first place
Pay is worked out by multiplying your hours by your rate, and a payroll system can't multiply "7 hours 45 minutes" by 20; it needs 7.75. That's the whole reason most payroll software, freelance invoicing apps and spreadsheet templates ask for decimal hours. The trouble is that minutes don't behave like decimals. An hour has 60 of them, not 100, so 45 minutes is three quarters of an hour (0.75), not 0.45.
Divide the minutes by 60
That's the entire method.
- 45 minutes ÷ 60 = 0.75
- 20 minutes ÷ 60 = 0.33 (strictly 0.333…, but two decimal places is the norm)
- 10 minutes ÷ 60 = 0.17
Then stick the whole hours in front, so 7 hours 45 minutes becomes 7.75, 8 hours 20 minutes becomes 8.33 and 40 hours 10 minutes becomes 40.17. If you'd rather skip the division altogether, the time to decimal calculator does it and has a chart for every minute from 1 to 60.
The ones worth memorising
Most shifts finish on a 5-minute mark, so this little table covers nearly everything you'll meet:
| Minutes | Decimal | Minutes | Decimal |
|---|---|---|---|
| 5 | 0.08 | 35 | 0.58 |
| 10 | 0.17 | 40 | 0.67 |
| 15 | 0.25 | 45 | 0.75 |
| 20 | 0.33 | 50 | 0.83 |
| 25 | 0.42 | 55 | 0.92 |
| 30 | 0.50 | 60 | 1.00 |
A quick sanity check: the quarter hours are 0.25, 0.50 and 0.75, so if your figure for 45 minutes doesn't end in .75, something's gone wrong.
What typing 7.45 actually costs you
Say you worked 7 hours 45 minutes and typed 7.45. The right figure is 7.75, so you've knocked 0.30 of an hour off, which is 18 minutes. At 20 an hour that's 6 gone in a single day, and if you make the same slip every day of a five-day week, 30 has disappeared before anyone notices.
It cuts the other way too. A freelancer who types 2.30 for "2 hours 30 minutes" is billing for 2 hours 18 minutes instead of 2.5 hours.
Total the week first, then convert once
For a full week it's more accurate to add up the hours and minutes and convert once at the end. A typical week might look like this:
- Monday: 8 h 15 min
- Tuesday: 7 h 50 min
- Wednesday: 8 h 40 min
- Thursday: 8 h 05 min
- Friday: 7 h 30 min
That comes to 40 hours 20 minutes, or 40.33 hours. Here, converting each day and adding the decimals happens to give the same answer, but over a longer pay period small rounding differences creep in: three separate 20-minute entries rounded to 0.33 each add up to 0.99, not 1.00. Converting the total once avoids that. The hours worked calculator adds up a whole week of clock-in and clock-out times and hands you the decimal total.
Going back from decimals to minutes
Keep the whole number and multiply whatever's after the decimal point by 60.
- 6.4 hours: 0.4 × 60 = 24, so 6 hours 24 minutes
- 7.75 hours: 0.75 × 60 = 45, so 7 hours 45 minutes
- 0.44 hours: 0.44 × 60 = 26.4, so 26 minutes 24 seconds
You'll need this when a payslip says something like 37.6 hours and you want to check it against your own notes. (37.6 hours is 37 hours 36 minutes.)
In Excel or Google Sheets
Spreadsheets store a time like 7:45 as a fraction of a day, which is why multiplying it by 24 gives you hours. If cell A2 holds 7:45:
=A2*24gives 7.75=ROUND(A2*24, 2)gives 7.75 rounded to two places, which is what most payroll sheets expect
Format the answer cell as a number. Leave it as a time format and you'll see something odd like 18:00 where 7.75 should be. To go the other way, divide decimal hours by 24 and format the cell as a time.
If your employer's figure doesn't match yours
Rounding is the usual reason. Plenty of employers round to the nearest quarter hour, so 7 hours 50 minutes might go down as 7.75 or 8.00 depending on their rule, while others pay to the exact minute. If the numbers look slightly off, ask how your workplace handles it before assuming anyone made a mistake.
Quick answers
- 15 minutes is 0.25 and 20 minutes is 0.33.
- 30 minutes is 0.5 and 45 minutes is 0.75.
- 1 hour 15 minutes is 1.25.
- And 7.5 hours is 7 hours 30 minutes, not 7 hours 50.