Updated July 1, 2026
Skip the arithmetic
The time card calculator converts every entry to decimal hours automatically.
To convert minutes to decimal hours, divide the number of minutes by 60. Then add that decimal to the whole hours. For example, 2 hours 45 minutes becomes 2 + (45/60) = 2.75 hours. This is the number you multiply by the hourly wage to calculate pay.
Why payroll requires decimal hours
Entering "8:15" into a payroll field as 8.15 would underpay the employee. Eight hours and 15 minutes is actually 8.25 hours (15/60 = 0.25), so the correct entry is 8.25. A small error like this repeated daily adds up to a meaningful underpayment over a year.
The full conversion chart
| Minutes | Decimal hours | Minutes | Decimal hours |
|---|---|---|---|
| 1 | 0.02 | 31 | 0.52 |
| 5 | 0.08 | 35 | 0.58 |
| 10 | 0.17 | 40 | 0.67 |
| 15 | 0.25 | 45 | 0.75 |
| 20 | 0.33 | 50 | 0.83 |
| 25 | 0.42 | 55 | 0.92 |
| 30 | 0.50 | 60 | 1.00 |
Quick reference for the four most common breaks
- 15 minutes = 0.25 hours
- 30 minutes = 0.50 hours
- 45 minutes = 0.75 hours
- 60 minutes = 1.00 hours
Converting a full timesheet row
Say an employee worked 78 hours and 45 minutes over a two-week pay period. Convert the minutes: 45 / 60 = 0.75. Total payroll hours = 78.75. At $17.50/hr, gross pay for the period is 78.75 x $17.50 = $1,378.13. For hours beyond 40 in either week, see how to calculate overtime.
Reverse conversion: decimal back to minutes
Multiply the decimal portion by 60. If a report shows 7.33 hours, the minutes are 0.33 x 60 = approximately 20 minutes, so the actual time is 7 hours 20 minutes. This is useful when reading automated reports and translating them back to clock notation.
Full 60-minute conversion table by single-minute increment
The table above covers common intervals. Here is every minute from 1 to 30 for reference when exact precision matters:
| Minutes | Decimal | Minutes | Decimal | Minutes | Decimal |
|---|---|---|---|---|---|
| 1 | 0.017 | 11 | 0.183 | 21 | 0.350 |
| 2 | 0.033 | 12 | 0.200 | 22 | 0.367 |
| 3 | 0.050 | 13 | 0.217 | 23 | 0.383 |
| 4 | 0.067 | 14 | 0.233 | 24 | 0.400 |
| 5 | 0.083 | 15 | 0.250 | 25 | 0.417 |
| 6 | 0.100 | 16 | 0.267 | 26 | 0.433 |
| 7 | 0.117 | 17 | 0.283 | 27 | 0.450 |
| 8 | 0.133 | 18 | 0.300 | 28 | 0.467 |
| 9 | 0.150 | 19 | 0.317 | 29 | 0.483 |
| 10 | 0.167 | 20 | 0.333 | 30 | 0.500 |
How employer time-rounding affects decimal hours
Some employers round employee punch times to the nearest 5 minutes, 6 minutes (tenth of an hour), or 15 minutes before converting to decimals. The most common system is the tenth-of-an-hour rounding, which divides each hour into six 10-minute blocks:
- 0 to 5 minutes past the hour rounds down to the hour (0.0 hours)
- 6 to 15 minutes rounds to 0.1 hours (6 minutes)
- 16 to 25 minutes rounds to 0.2 hours (12 minutes)
- 26 to 35 minutes rounds to 0.3 hours (18 minutes)
- 36 to 45 minutes rounds to 0.4 hours (24 minutes)
- 46 to 55 minutes rounds to 0.5 hours (30 minutes)
- 56 to 59 minutes rounds to 0.9 hours, and so on through full-hour increments
Rounding is permissible under federal guidance only when it is applied neutrally so that it does not consistently under-compensate employees over time. If you believe rounding is systematically reducing your paycheck, compare your actual punch times against the rounded totals each pay period. This article is for educational purposes and is not legal advice.
Decimal hours in Excel and Google Sheets
Spreadsheet programs store time values as fractions of a day. One hour is 1/24 of a day, so a cell showing "8:30" (8 hours 30 minutes) is stored internally as 0.3542. To convert it to decimal payroll hours, multiply by 24: =A1*24 gives 8.5. If your cell shows a time-formatted result instead of 8.5, change the cell format from "Time" to "Number." A common payroll formula for a single row is =(B2-A2)*24-C2, where B2 is clock-out, A2 is clock-in, and C2 is the unpaid break in decimal hours (enter 0.5 for a 30-minute break). Use the time card calculator for an instant conversion without spreadsheet setup.
Common errors to avoid when entering decimal hours
Even with the formula memorized, these mistakes appear frequently in timesheets and payroll entries:
- Treating minutes as cents: Entering 8 hours 20 minutes as 8.20 instead of 8.33 underpays the employee by about 13 cents per hour worked. Over a full year that small error compounds to several dollars.
- Forgetting to convert break time: If you subtract a break, subtract it in decimal form too. A 45-minute break is 0.75 hours, not 0.45.
- Rounding too aggressively: Rounding 8.17 down to 8.0 for convenience removes 10 minutes of pay per day. Use at least two decimal places for payroll accuracy.
- Adding hours and minutes columns separately: If one column holds hours and another holds minutes, you cannot simply add the totals without first converting the minutes column to decimals. Add all minutes together, divide by 60, then add the whole-hour quotient to your hours column and carry any remainder.
When in doubt, use the time card calculator to do the conversion automatically. Also review how to calculate a timesheet with lunch breaks to make sure break deductions are handled correctly before converting to decimals.
Skip the arithmetic
The time card calculator converts every entry to decimal hours automatically.