The formula
Decimal hours = hours + minutes ÷ 60. 7 hours 48 minutes = 7 + 48 ÷ 60 = 7.80 hours. To go back, multiply the decimal part by 60: 7.80 hours → 0.80 × 60 = 48 minutes. If your employer rounds, use the two-place column; if you need precision for totals, keep three places and round once at the end.
Minutes to decimal hours, 1 to 60
| Minutes | Decimal (2 places) | Decimal (3 places) |
|---|---|---|
| 1 | 0.02 | 0.017 |
| 2 | 0.03 | 0.033 |
| 3 | 0.05 | 0.050 |
| 4 | 0.07 | 0.067 |
| 5 | 0.08 | 0.083 |
| 6 | 0.10 | 0.100 |
| 7 | 0.12 | 0.117 |
| 8 | 0.13 | 0.133 |
| 9 | 0.15 | 0.150 |
| 10 | 0.17 | 0.167 |
| 11 | 0.18 | 0.183 |
| 12 | 0.20 | 0.200 |
| 13 | 0.22 | 0.217 |
| 14 | 0.23 | 0.233 |
| 15 | 0.25 | 0.250 |
| 16 | 0.27 | 0.267 |
| 17 | 0.28 | 0.283 |
| 18 | 0.30 | 0.300 |
| 19 | 0.32 | 0.317 |
| 20 | 0.33 | 0.333 |
| 21 | 0.35 | 0.350 |
| 22 | 0.37 | 0.367 |
| 23 | 0.38 | 0.383 |
| 24 | 0.40 | 0.400 |
| 25 | 0.42 | 0.417 |
| 26 | 0.43 | 0.433 |
| 27 | 0.45 | 0.450 |
| 28 | 0.47 | 0.467 |
| 29 | 0.48 | 0.483 |
| 30 | 0.50 | 0.500 |
| 31 | 0.52 | 0.517 |
| 32 | 0.53 | 0.533 |
| 33 | 0.55 | 0.550 |
| 34 | 0.57 | 0.567 |
| 35 | 0.58 | 0.583 |
| 36 | 0.60 | 0.600 |
| 37 | 0.62 | 0.617 |
| 38 | 0.63 | 0.633 |
| 39 | 0.65 | 0.650 |
| 40 | 0.67 | 0.667 |
| 41 | 0.68 | 0.683 |
| 42 | 0.70 | 0.700 |
| 43 | 0.72 | 0.717 |
| 44 | 0.73 | 0.733 |
| 45 | 0.75 | 0.750 |
| 46 | 0.77 | 0.767 |
| 47 | 0.78 | 0.783 |
| 48 | 0.80 | 0.800 |
| 49 | 0.82 | 0.817 |
| 50 | 0.83 | 0.833 |
| 51 | 0.85 | 0.850 |
| 52 | 0.87 | 0.867 |
| 53 | 0.88 | 0.883 |
| 54 | 0.90 | 0.900 |
| 55 | 0.92 | 0.917 |
| 56 | 0.93 | 0.933 |
| 57 | 0.95 | 0.950 |
| 58 | 0.97 | 0.967 |
| 59 | 0.98 | 0.983 |
| 60 | 1.00 | 1.000 |
Common time card examples
| Time worked | Decimal hours | At $20/hour |
|---|---|---|
| 7 h 20 min | 7.33 | $146.67 |
| 7 h 45 min | 7.75 | $155.00 |
| 8 h 10 min | 8.17 | $163.33 |
| 8 h 25 min | 8.42 | $168.33 |
| 8 h 50 min | 8.83 | $176.67 |
| 38 h 10 min | 38.17 | $763.33 |
Pay amounts use the unrounded hours (7 h 20 min × $20 = 7.333… × 20). Rounding the hours to two places first can move the total by a few cents.
In Excel or Google Sheets
- Minutes in A2:
=A2/60 - A time value such as 7:48 in B2:
=B2*24(format the result as Number), because Excel stores time as a fraction of a day (Microsoft). - Hours and minutes in separate cells:
=C2+D2/60 - Decimal back to time:
=E2/24, formatted as[h]:mm.
To get the hours themselves from clock-in and clock-out times, see how to calculate hours worked, with a calculator.
The app we're building
What the app will do that this page can't: We're building Hours Calculator, an iPhone app that will keep every day on your iPhone, total the week and the month on its own, show overtime with the estimated pay from your hourly rate and export a PDF time card, with no account and no internet. It is not on the App Store yet: leave your email and we will tell you when it launches.