WorkFlowConverting decimal hours: the formulas
- Minutes to decimal hours
- Minutes ÷ 60. Example: 45 ÷ 60 = 0.75 hours.
- Hundredths to minutes
- Hundredths × 0.6. Example: 75 × 0.6 = 45 minutes.
- Hours and minutes to decimal hours
- Hours + minutes ÷ 60. Example: 7 hours 45 minutes = 7 + 0.75 = 7.75 hours.
- Decimal hours to hours and minutes
- The decimal part × 60 gives the minutes. Example: 8.20 hours: 0.20 × 60 = 12, so 8 hours 12 minutes.
The most common mix-up: 8.20 hours are not 8:20. Eight hours and twenty minutes would be 8.33 hours.
Chart: minutes to decimal hours
Every minute of an hour, converted. For more than an hour, count the full hours first: 2 hours 45 minutes are 2.75 hours.
| Minutes | Hundredths | Decimal hours |
|---|---|---|
| 1 | 1.67 | 0.02 |
| 2 | 3.33 | 0.03 |
| 3 | 5.00 | 0.05 |
| 4 | 6.67 | 0.07 |
| 5 | 8.33 | 0.08 |
| 6 | 10.00 | 0.10 |
| 7 | 11.67 | 0.12 |
| 8 | 13.33 | 0.13 |
| 9 | 15.00 | 0.15 |
| 10 | 16.67 | 0.17 |
| 11 | 18.33 | 0.18 |
| 12 | 20.00 | 0.20 |
| 13 | 21.67 | 0.22 |
| 14 | 23.33 | 0.23 |
| 15 | 25.00 | 0.25 |
| Minutes | Hundredths | Decimal hours |
|---|---|---|
| 16 | 26.67 | 0.27 |
| 17 | 28.33 | 0.28 |
| 18 | 30.00 | 0.30 |
| 19 | 31.67 | 0.32 |
| 20 | 33.33 | 0.33 |
| 21 | 35.00 | 0.35 |
| 22 | 36.67 | 0.37 |
| 23 | 38.33 | 0.38 |
| 24 | 40.00 | 0.40 |
| 25 | 41.67 | 0.42 |
| 26 | 43.33 | 0.43 |
| 27 | 45.00 | 0.45 |
| 28 | 46.67 | 0.47 |
| 29 | 48.33 | 0.48 |
| 30 | 50.00 | 0.50 |
| Minutes | Hundredths | Decimal hours |
|---|---|---|
| 31 | 51.67 | 0.52 |
| 32 | 53.33 | 0.53 |
| 33 | 55.00 | 0.55 |
| 34 | 56.67 | 0.57 |
| 35 | 58.33 | 0.58 |
| 36 | 60.00 | 0.60 |
| 37 | 61.67 | 0.62 |
| 38 | 63.33 | 0.63 |
| 39 | 65.00 | 0.65 |
| 40 | 66.67 | 0.67 |
| 41 | 68.33 | 0.68 |
| 42 | 70.00 | 0.70 |
| 43 | 71.67 | 0.72 |
| 44 | 73.33 | 0.73 |
| 45 | 75.00 | 0.75 |
| Minutes | Hundredths | Decimal hours |
|---|---|---|
| 46 | 76.67 | 0.77 |
| 47 | 78.33 | 0.78 |
| 48 | 80.00 | 0.80 |
| 49 | 81.67 | 0.82 |
| 50 | 83.33 | 0.83 |
| 51 | 85.00 | 0.85 |
| 52 | 86.67 | 0.87 |
| 53 | 88.33 | 0.88 |
| 54 | 90.00 | 0.90 |
| 55 | 91.67 | 0.92 |
| 56 | 93.33 | 0.93 |
| 57 | 95.00 | 0.95 |
| 58 | 96.67 | 0.97 |
| 59 | 98.33 | 0.98 |
| 60 | 100.00 | 1.00 |
Hundredths and decimal hours rounded to two decimals. Only multiples of 3 minutes come out exactly: 3 minutes are exactly 0.05 hours.
Chart as a printable PDF (A4, with the way back and the formulas) ↓
Back to minutes: hundredths of an hour
In steps of five, hundredths always come out as whole minutes: 0.05 hours are exactly 3 minutes.
| Hundredths | Minutes |
|---|---|
| 5 | 3 |
| 10 | 6 |
| 15 | 9 |
| 20 | 12 |
| 25 | 15 |
| 30 | 18 |
| 35 | 21 |
| 40 | 24 |
| 45 | 27 |
| 50 | 30 |
| Hundredths | Minutes |
|---|---|
| 55 | 33 |
| 60 | 36 |
| 65 | 39 |
| 70 | 42 |
| 75 | 45 |
| 80 | 48 |
| 85 | 51 |
| 90 | 54 |
| 95 | 57 |
| 100 | 60 |
Converting in Excel
Excel stores a time as a fraction of a day. Times 24 turns it into decimal hours, divided by 24 back into a time.
- Time to decimal hours
=A1*247:45 in A1 gives 7.75.- Hours from start to end
=(B1-A1)*2407:45 to 17:15 gives 9.5.- Shift past midnight
=MOD(B1-A1,1)*2422:00 to 06:00 gives 8.- Decimal hours to a time
=A1/248.2 gives 8:12, cell formatted as [h]:mm.
Format the result cell of a decimal hour as a number, or Excel shows it as a time again. In a German Excel, MOD is called REST and arguments are separated by a semicolon.
What are industrial minutes?
In German-speaking countries a hundredth of an hour is called an industrial minute (Industrieminute). An hour has 100 of them, and one lasts 36 seconds. It is the same idea as decimal hours: time counted in tenths and hundredths instead of sixtieths.[1]
The point is that times can be added like ordinary numbers and multiplied by an hourly rate. That is why payroll, time clocks, job costing and many timesheets use decimal hours: 0.75 hours are 75 industrial minutes.
Examples from a working week
- Working out pay. 7 hours 30 minutes at 16.50 an hour: 7.5 × 16.50 = 123.75. Calculating with 7.30 by mistake gives 120.45, which is 3.30 short.
- Reading a timesheet. If the net column says 8.20, you worked 8 hours and 12 minutes. A balance of +1.20 hours is 1 hour and 12 minutes.
- Adding up a week. 8:15 + 7:45 + 8:30 + 8:00 + 6:50 gives 39:20, in decimal hours 8.25 + 7.75 + 8.5 + 8 + 6.83 = 39.33 hours.
- Staying exact. Calculate with whole minutes and round only the result. Rounding every line to two decimals collects small errors for minute values not divisible by 3.
Or stop calculating altogether.
WorkFlow tracks your working time automatically when you arrive at and leave your workplace, shows it in hours and minutes and exports the month as a timesheet PDF in decimal hours. Free, no ads, no account.
Frequent questions
How do I convert minutes to decimal hours?
Divide the minutes by 60. 45 minutes are 0.75 hours, 15 minutes are 0.25 and 30 minutes are 0.5.
What is 8.20 hours in hours and minutes?
8 hours and 12 minutes. The decimal part 0.20 times 60 gives 12 minutes.
How many minutes is 0.1 hours?
6 minutes. Every tenth of an hour is 6 minutes, every hundredth 36 seconds.
How do I convert decimal hours in Excel?
Multiply a time by 24: =A1*24 turns 7:45 into 7.75. Divide by 24 to go back, and format that cell as [h]:mm.
What are industrial minutes?
The German name for hundredths of an hour. 75 industrial minutes are 0.75 hours.
Why does my timesheet show 7.50 instead of 7:30?
Because it uses decimal hours. 7.50 hours are 7 hours and 30 minutes, which can be multiplied by an hourly rate directly.
Source
Written by Ivan Knezevic, developer of WorkFlow, Zürich. Updated on 6 October 2026.