How to convert time to decimal hours
- Choose the direction. Pick “time to decimal” to convert hours and minutes, or “decimal to time” to read a decimal back as hours and minutes.
- Enter the duration. Type hours, minutes and optional seconds, or paste a value such as 7:45, 1:20:30 or 2h 15m into the quick box.
- Pick the decimal places. Two places suit most invoices and payroll sheets. Use three or four when you add many short entries later.
- Add a rate (optional). Enter your hourly rate to see the amount from the exact time and from the rounded quantity, side by side.
- Copy the result. Copy the decimal into your timesheet, spreadsheet or the quantity box of an invoice line.
How the conversion works
Clock time counts in sixties, decimals count in tens. To convert, keep the whole hours and divide the rest by 60 (minutes) or 3,600 (seconds):
decimal hours = hours + minutes ÷ 60 + seconds ÷ 3,600
Going the other way, the whole number is the hours, and the part after the point × 60 gives the minutes. For 6.4 hours: 0.4 × 60 = 24, so 6.4 hours is 6 hours 24 minutes.
The trap is reading the minutes as if they were already decimals. 1 hour 20 minutes is 1.33 hours, not 1.20. 1.20 hours is only 1 hour 12 minutes. On an invoice at 90 an hour, writing 1.20 instead of 1.33 leaves 12 unbilled, and the error repeats on every entry.
Worked examples for timesheets and invoices
| Duration | Calculation | Decimal hours | At 60 / hour |
|---|---|---|---|
| 7 h 45 min | 7 + 45 ÷ 60 | 7.75 | 465.00 |
| 8 h 30 min | 8 + 30 ÷ 60 | 8.50 | 510.00 |
| 1 h 20 min | 1 + 20 ÷ 60 | 1.3333… (1.33) | 80.00 exact, 79.80 from 1.33 |
| 0 h 50 min | 50 ÷ 60 | 0.8333… (0.83) | 50.00 exact, 49.80 from 0.83 |
| 2 h 10 min 30 s | 2 + 10 ÷ 60 + 30 ÷ 3,600 | 2.175 (2.18) | 130.50 |
| 37 h 15 min (a week) | 37 + 15 ÷ 60 | 37.25 | 2,235.00 |
Where the decimal repeats (20, 40, 50 minutes and so on), two decimal places can move the amount by a few cents or pence per line. Add up all the entries in minutes first and convert the total once, or use four decimal places for the quantity, so small differences do not pile up. The calculator shows both figures when you enter a rate.
Minutes to decimal hours chart
Values are minutes ÷ 60, rounded to two places. Add the decimal to your whole hours: 3 hours 36 minutes is 3 + 0.60 = 3.60.
| Min | Decimal | Min | Decimal | Min | Decimal |
|---|---|---|---|---|---|
| 1 | 0.02 | 21 | 0.35 | 41 | 0.68 |
| 2 | 0.03 | 22 | 0.37 | 42 | 0.70 |
| 3 | 0.05 | 23 | 0.38 | 43 | 0.72 |
| 4 | 0.07 | 24 | 0.40 | 44 | 0.73 |
| 5 | 0.08 | 25 | 0.42 | 45 | 0.75 |
| 6 | 0.10 | 26 | 0.43 | 46 | 0.77 |
| 7 | 0.12 | 27 | 0.45 | 47 | 0.78 |
| 8 | 0.13 | 28 | 0.47 | 48 | 0.80 |
| 9 | 0.15 | 29 | 0.48 | 49 | 0.82 |
| 10 | 0.17 | 30 | 0.50 | 50 | 0.83 |
| 11 | 0.18 | 31 | 0.52 | 51 | 0.85 |
| 12 | 0.20 | 32 | 0.53 | 52 | 0.87 |
| 13 | 0.22 | 33 | 0.55 | 53 | 0.88 |
| 14 | 0.23 | 34 | 0.57 | 54 | 0.90 |
| 15 | 0.25 | 35 | 0.58 | 55 | 0.92 |
| 16 | 0.27 | 36 | 0.60 | 56 | 0.93 |
| 17 | 0.28 | 37 | 0.62 | 57 | 0.95 |
| 18 | 0.30 | 38 | 0.63 | 58 | 0.97 |
| 19 | 0.32 | 39 | 0.65 | 59 | 0.98 |
| 20 | 0.33 | 40 | 0.67 | 60 | 1.00 |
Handy anchors: 6 minutes = 0.10, 12 = 0.20, 15 = 0.25, 30 = 0.50, 45 = 0.75. The six-minute steps are why many professionals bill in tenths of an hour.
Decimal places versus billing increments
Choosing two or four decimal places only changes how precisely the same time is written. It is not the same as a billing increment. Rounding every task up to 6, 15 or 30 minutes is a pricing rule that should be in your contract or terms, and it changes the time you charge. If you bill in increments, apply the increment first, then convert. The timesheet invoice generator does both for a list of dated entries and sends the lines straight to an invoice.
In a spreadsheet
Excel and Google Sheets store a time as a fraction of a day. Multiply the cell by 24 and format the result as a number: =A2*24. For separate hour and minute columns use =A2+B2/60. Format durations over 24 hours as [h]:mm so they do not wrap round.
One week, four ways to round: what each one bills
The same timesheet can produce noticeably different invoices depending on the rounding rule. Here is one illustrative week of ten task entries, billed at 80 an hour.
| Entry | Minutes | Decimal (2 places) | Up to 6 min | Up to 15 min | Nearest 15 min |
|---|---|---|---|---|---|
| Mon – client call | 23 | 0.38 | 0.4 | 0.50 | 0.50 |
| Mon – bug fix | 52 | 0.87 | 0.9 | 1.00 | 0.75 |
| Tue – design review | 38 | 0.63 | 0.7 | 0.75 | 0.75 |
| Tue – emails | 9 | 0.15 | 0.2 | 0.25 | 0.25 |
| Wed – build feature | 134 | 2.23 | 2.3 | 2.25 | 2.25 |
| Wed – deploy | 17 | 0.28 | 0.3 | 0.50 | 0.25 |
| Thu – workshop | 95 | 1.58 | 1.6 | 1.75 | 1.50 |
| Thu – follow-up notes | 14 | 0.23 | 0.3 | 0.25 | 0.25 |
| Fri – testing | 71 | 1.18 | 1.2 | 1.25 | 1.25 |
| Fri – status report | 26 | 0.43 | 0.5 | 0.50 | 0.50 |
| Total hours | 479 min | 7.96 | 8.40 | 9.00 | 8.25 |
| At 80 / hour | 638.67 | 636.80 | 672.00 | 720.00 | 660.00 |
What the table shows:
- Exact time is 479 minutes, or 479 ÷ 60 = 7.9833 hours, worth 638.67. That is the baseline.
- Two decimal places per line totals 7.96 hours, or 636.80: 1.87 less than the exact figure, purely from rounding each line separately. Totalling minutes first avoids it.
- Rounding each entry up to 6 minutes (tenths of an hour) bills 504 minutes, 5.2% more than worked.
- Rounding each entry up to 15 minutes bills 540 minutes, 61 minutes or 12.7% more. Short tasks such as a 9-minute email batch are where the gap comes from.
- Rounding each entry to the nearest 15 minutes rounds some down (52 to 45, 95 to 90) and some up, and lands at 495 minutes, 3.3% over in this week; in another week it could land under.
If you round, apply the rule to the right unit and say which one in your terms. Rounding the weekly total of 479 minutes up to the next 15 minutes gives 480 minutes (8.00 hours, 640.00), far closer to the time actually worked than rounding all ten entries. Clients who receive the detailed entries can check any of these figures, so pick the rule you are comfortable defending line by line.
Putting decimal hours on an invoice
On an hourly invoice line, the quantity is the decimal hours and the unit price is your hourly rate. Write the description so the client can check it, for example “Website fixes, 4 Nov, 2 h 45 min”, with 2.75 in the quantity column. If you are not sure what to charge per hour in the first place, the hourly rate calculator works it out from your income target, costs and billable hours. Then add the line in the invoice generator and download the PDF.
Glossary
- Decimal hours
- A duration written as a base-10 number of hours, such as 7.75 for 7 hours 45 minutes.
- h:mm
- Clock-style duration in hours and minutes, such as 7:45.
- Billing increment
- A block of time, such as 6 or 15 minutes, that each task is rounded to under your terms.
- Quantity
- On an hourly invoice line, the number of hours being charged.
Frequently asked questions
How do I convert hours and minutes to decimal?
Is 1.30 hours the same as 1 hour 30 minutes?
What is 20 minutes as a decimal?
How do I convert decimal hours back to minutes?
How many decimal places should I use on an invoice?
Can I convert durations longer than 24 hours?
Does the calculator round my time up to 15 minutes?
How do I convert time to decimal in Excel?
Should I round each time entry or the weekly total?
Is rounding to the nearest 15 minutes the same as rounding up?
Is my data stored?
Related topics
- time to decimal calculator
- hours to decimal
- minutes to decimal
- decimal hours to minutes
- convert time to decimal
- decimal time chart
- timesheet decimal hours
- hours and minutes to decimal