Time to decimal calculator

Time to decimal calculator

Turn a duration such as 7 hours 45 minutes into decimal hours (7.75) for a timesheet, payroll sheet or invoice quantity, or turn a decimal such as 7.3 back into hours and minutes. Add your hourly rate to see what the line is worth and how much rounding changes it.

  • ✓ Hours & minutes → decimal
  • ✓ Decimal → h:mm
  • ✓ Seconds supported
  • ✓ Rounding check at your rate

Your numbers

Overrides the boxes below when filled in.

Result

Decimal hours

–

Converts exactly; only the displayed decimal is rounded. Billing increments are not applied.

How to convert time to decimal hours

  1. 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.
  2. 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.
  3. Pick the decimal places. Two places suit most invoices and payroll sheets. Use three or four when you add many short entries later.
  4. Add a rate (optional). Enter your hourly rate to see the amount from the exact time and from the rounded quantity, side by side.
  5. 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

DurationCalculationDecimal hoursAt 60 / hour
7 h 45 min7 + 45 ÷ 607.75465.00
8 h 30 min8 + 30 ÷ 608.50510.00
1 h 20 min1 + 20 ÷ 601.3333… (1.33)80.00 exact, 79.80 from 1.33
0 h 50 min50 ÷ 600.8333… (0.83)50.00 exact, 49.80 from 0.83
2 h 10 min 30 s2 + 10 ÷ 60 + 30 ÷ 3,6002.175 (2.18)130.50
37 h 15 min (a week)37 + 15 ÷ 6037.252,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.

MinDecimalMinDecimalMinDecimal
10.02210.35410.68
20.03220.37420.70
30.05230.38430.72
40.07240.40440.73
50.08250.42450.75
60.10260.43460.77
70.12270.45470.78
80.13280.47480.80
90.15290.48490.82
100.17300.50500.83
110.18310.52510.85
120.20320.53520.87
130.22330.55530.88
140.23340.57540.90
150.25350.58550.92
160.27360.60560.93
170.28370.62570.95
180.30380.63580.97
190.32390.65590.98
200.33400.67601.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.

EntryMinutesDecimal (2 places)Up to 6 minUp to 15 minNearest 15 min
Mon – client call230.380.40.500.50
Mon – bug fix520.870.91.000.75
Tue – design review380.630.70.750.75
Tue – emails90.150.20.250.25
Wed – build feature1342.232.32.252.25
Wed – deploy170.280.30.500.25
Thu – workshop951.581.61.751.50
Thu – follow-up notes140.230.30.250.25
Fri – testing711.181.21.251.25
Fri – status report260.430.50.500.50
Total hours479 min7.968.409.008.25
At 80 / hour638.67636.80672.00720.00660.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?
Divide the minutes by 60 and add the whole hours. 7 hours 45 minutes is 7 + 45 ÷ 60 = 7.75 hours.
Is 1.30 hours the same as 1 hour 30 minutes?
No. 1.30 hours is 1 hour 18 minutes (0.30 × 60 = 18). One and a half hours is 1.50.
What is 20 minutes as a decimal?
20 ÷ 60 = 0.3333…, shown as 0.33 to two places. So 1 hour 20 minutes is about 1.33 hours.
How do I convert decimal hours back to minutes?
Multiply the part after the point by 60. 0.75 × 60 = 45, so 8.75 hours is 8 hours 45 minutes.
How many decimal places should I use on an invoice?
Two is the usual choice and easy for clients to read. If you add many short entries, use more places or total the minutes first, so the rounding does not add up across lines.
Can I convert durations longer than 24 hours?
Yes. Enter the total hours, for example 37 hours 15 minutes for a week, and the calculator returns 37.25.
Does the calculator round my time up to 15 minutes?
No. It converts exactly and only rounds the displayed decimal. Billing increments such as 6 or 15 minutes are a separate pricing rule; the timesheet invoice generator applies them if you choose one.
How do I convert time to decimal in Excel?
Multiply the time cell by 24 and format the result as a number, for example =A2*24. A value of 7:45 becomes 7.75.
Should I round each time entry or the weekly total?
Rounding each entry up adds a little to every task, so ten short entries in a week can add an hour or more. Rounding only the total adds at most one increment. Whichever you use, state it in your terms so the client can check the invoice.
Is rounding to the nearest 15 minutes the same as rounding up?
No. Rounding up bills any part of a block as a full block, so 17 minutes becomes 30. Rounding to the nearest block sends 7 minutes or less down and 8 or more up, so 17 minutes becomes 15 and 23 becomes 30.
Is my data stored?
Only in your browser, so a refresh keeps your numbers. Nothing is uploaded, and Reset clears it.

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