Minutes to decimal hours formula
Decimal hours = whole hours + (minutes ÷ 60)
- Keep the hours as they are: in 7:45 that is 7.
- Divide the minutes by 60: 45 ÷ 60 = 0.75.
- Add them: 7 + 0.75 = 7.75.
The quarter hours are worth remembering: 15 minutes = 0.25, 30 minutes = 0.50, 45 minutes = 0.75. Everything else is a division you can check in the chart.
Clocktape shows every total as h:mm, decimal hours and minutes at once, with decimal hours set to 1, 2 or 3 places. Get it on Google Play
Minutes to decimal hours conversion chart
Values are minutes ÷ 60, rounded to two decimal places.
| Min | Hours | Min | Hours | Min | Hours |
|---|---|---|---|---|---|
| 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 |
Decimal hours to minutes
Going the other way, multiply the decimal part by 60.
| Decimal hours | Calculation | Hours and minutes |
|---|---|---|
| 7.6 | 0.6 × 60 = 36 | 7:36 |
| 38.25 | 0.25 × 60 = 15 | 38:15 |
| 5.53 | 0.53 × 60 = 31.8 | about 5:32 |
| 0.4 | 0.4 × 60 = 24 | 0:24 |
The third row shows why decimals do not always map back to whole minutes: once a value has been rounded, the exact minute is gone. Keep the original hours and minutes if you might need them later.
Rounding: 1, 2 or 3 decimal places
The same time gives slightly different decimals depending on how many places you keep. Take 7:43, which is 7 + 43 ÷ 60 = 7.71666…
| Places | Result | Difference from exact |
|---|---|---|
| 1 | 7.7 | about 1 minute short |
| 2 | 7.72 | about 0.2 of a minute over |
| 3 | 7.717 | a fraction of a second |
Two places is common on timesheets. One place means the hour is split into tenths of 6 minutes each, which is why you will see charts where 1–2 minutes show as 0.0 and 3–8 minutes as 0.1. That is a rounding scheme, not an exact conversion, so use the chart your payroll team uses.
Round the total, not every line
If you round each day to two places and then add, small errors stack. Five days of 7:43 rounded to 7.72 each give 38.60, while the exact total is 38:35, which is 38.58. Add the hours and minutes first, then convert once.
Common mistakes on a time card
- Reading the minutes as a decimal. 1:30 is 1.50 hours, not 1.30.
- Converting seconds as if they were minutes. For h:mm:ss, divide seconds by 3,600: 0:00:30 is 0.0083 hours.
- Multiplying a pay rate by h:mm. At $20 an hour, 7:45 entered as 7.45 gives $149.00. The right figure is 7.75 × $20 = $155.00, so the slip costs $6 on a single day.
- Spreadsheet time showing as a fraction. Excel stores 7:45 as 0.3229 of a day. Multiply by 24 to get 7.75 hours, or divide minutes by 60 in a separate column.
Skip the chart next time
Type the times you worked into Clocktape and read the decimal total off the bottom of the tape, ready for a timesheet.
Get it on Google PlayiPhone version coming soon
More guides
- How to Calculate Hours Worked: Start, End, Breaks and Weekly TotalCalculate hours worked from start and end times: subtract, take off unpaid breaks, add the days, then convert to decimal hours. A full worked week included.
- How to Calculate Hours Worked Overnight (Shifts Past Midnight)When a shift ends after midnight, add 24 hours to the end time before subtracting. Night shift examples, breaks, splitting at midnight and spreadsheet formulas.
- Adding Hours and Minutes Together (and Subtracting Them)Add hours and minutes by adding each part, then carrying every 60 minutes into an hour. Examples for subtracting, totals over 24 hours, seconds, and multiplying time.
- How to Calculate Overtime Hours from a Time CardOvertime hours are the hours worked beyond your threshold. Total the week in hours and minutes, subtract the threshold, convert to decimals, check daily and weekly rules.
Published by Zoranta, the developer of Clocktape.