Decimal Hours: Converting Minutes for Timesheets
Updated October 24, 2026
Payroll and invoicing software wants 7.75 hours, not 7 hours 45 minutes. Clocks count in sixties and decimals count in tens, and the two look alike on paper, so 7:30 on a timecard gets typed as 7.30 and the shift comes up short. The conversion itself is one division. What makes it fiddly is everything around it: the colon, spreadsheet time cells, and the rounding your employer applies before you ever see the total.
Divide the minutes by 60
Fifteen minutes is 15 ÷ 60 = 0.25 hours, thirty is 0.5, forty-five is 0.75. Add the result to the whole hours: 7 hours 45 minutes is 7 + 0.75 = 7.75. For odd values, the Minute to Hour converter takes any number of minutes, or use the table.
| Minutes | Decimal hours | Two places |
|---|---|---|
| 1 | 0.016667 | 0.02 |
| 5 | 0.083333 | 0.08 |
| 6 | 0.1 | 0.10 |
| 10 | 0.16667 | 0.17 |
| 12 | 0.2 | 0.20 |
| 15 | 0.25 | 0.25 |
| 18 | 0.3 | 0.30 |
| 20 | 0.33333 | 0.33 |
| 25 | 0.41667 | 0.42 |
| 30 | 0.5 | 0.50 |
| 36 | 0.6 | 0.60 |
| 40 | 0.66667 | 0.67 |
| 45 | 0.75 | 0.75 |
| 48 | 0.8 | 0.80 |
| 50 | 0.83333 | 0.83 |
| 55 | 0.91667 | 0.92 |
Notice which rows come out clean. Every multiple of 6 minutes is a whole number of tenths (6 minutes is exactly 0.1 hours), and every multiple of 3 is a whole number of hundredths. Anything else repeats forever: 10 minutes is 0.1666… hours and 20 minutes is 0.3333…. That is why two decimal places is the usual payroll precision, and why 10 minutes shows up on a pay stub as 0.17.
7:30 is not 7.30
After a colon the digits are minutes, 0 to 59. After a decimal point they are hundredths. So 7 hours 30 minutes is 7.5 hours, and entering 7.30 underpays the shift by 0.2 hours, or 12 minutes. Do that on 20 shifts in a month and 4 hours of pay are gone. The gap widens as the minutes go up: 8:45 typed as 8.45 loses 0.3 hours, 18 minutes, in a single day. Heights written as 5.11 for 5 feet 11 inches go wrong for the same reason, as the height guide explains.
Spreadsheets hide the same problem one level down. Type 7:45 into a cell and Excel or Google Sheets stores it as a fraction of a day, not of an hour: 0.32292. Multiply the cell by 24 and format the result as a plain number to get decimal hours (0.32292 × 24 ≈ 7.75). Leave out the × 24 and a formula that multiplies the cell by an hourly rate comes out at one twenty-fourth of the right pay.
Reading a decimal back as clock time
Keep the whole number as hours and multiply only the fraction by 60. 6.4 hours is 6 hours plus 0.4 × 60 = 24 minutes. In this direction the digits after the point are not minutes either: 3.15 hours is 3 hours 9 minutes, not 3 hours 15. If you want a single figure to check against, the Hour to Minute converter gives total minutes; 6.4 hours is 384.
Total the week in minutes
Adding 8:15 to 7:50 by hand means carrying sixties, which is where weekly totals go wrong. Converting everything to minutes first avoids it. A week of 8:15, 7:50, 8:30, 9:05 and 6:40 is 495 + 470 + 510 + 545 + 400 = 2,420 minutes, and 2,420 ÷ 60 = 40.333 hours, or 40 hours 20 minutes. Converting each day first reaches the same total by way of 8.25 + 7.8333 + 8.5 + 9.0833 + 6.6667, with three repeating decimals to round along the way.
In a spreadsheet, watch the total cell. Formatted as h:mm, a sum past 24 hours wraps around, so that week displays as 16:20. In Excel, the custom format [h]:mm shows elapsed hours instead; Google Sheets calls the same thing Duration.
Clock rounding and the 7-minute rule
Many time clocks round punches to a fixed interval, commonly 5, 6 or 15 minutes. With quarter-hour rounding, 1 to 7 minutes past the quarter rounds down and 8 to 14 rounds up, hence the name 7-minute rule: a punch at 8:07 is recorded as 8:00, one at 8:08 as 8:15.
In the United States, federal rules allow rounding only if it is neutral over time, meaning it does not consistently favor the employer. The federal rule is in 29 CFR 785.48; some states are stricter, so check the rules where you work.
Six-minute rounding has a practical advantage: each unit is exactly 0.1 hours, so nothing repeats. That is why lawyers and consultants often bill in tenths of an hour, and why an invoice line reading 0.3 is billed as 18 minutes.
Where 2,080 comes from
A 40-hour week over 52 weeks is 2,080 hours, the figure usually used to turn an annual salary into an hourly rate; a 37.5-hour week gives 1,950. Neither figure subtracts holidays. For scale, a week is 168 hours and a year of 365.25 days, averaging in leap years, is 8,766 hours, so a 40-hour week covers a little under a quarter of the clock. The Week to Hour converter and Day to Hour converter cover the larger spans.