Minutes to Decimal Hours: Conversion Chart for Payroll

Time clocks show hours and minutes, but payroll multiplies pay rates by decimal hours. Getting the conversion wrong, such as reading 7.30 as 7 hours 30 minutes, quietly shortchanges or overpays someone every pay period. This guide gives a full 1–60 minute chart, the formula, worked pay examples and the federal rules on rounding.

The one-line conversion

Payroll systems, spreadsheets and most time clocks store hours as decimals, while people read clocks in hours and minutes. The conversion is simple: divide the minutes by 60. Thirty minutes is 30 ÷ 60 = 0.50 hours, fifteen minutes is 0.25 hours, and 7 minutes is 7 ÷ 60 = 0.1167 hours, which is usually shown as 0.12. To convert a full time such as 7 hours 45 minutes, convert only the minutes and add them to the whole hours: 45 ÷ 60 = 0.75, so the total is 7.75 hours.

The mistake that causes most payroll errors is treating the digits after the decimal point as minutes. 7.30 hours is not 7 hours 30 minutes. It is 7 hours plus 0.30 × 60 = 18 minutes. The number 7.5 hours is 7 hours 30 minutes. If you only remember one thing from this page, remember that a decimal hour is a fraction of 60 minutes, not a count of minutes.

Minutes-to-decimal-hours chart (1–60 minutes)

Use this chart to convert any number of minutes. Values are rounded to two decimal places, which is accurate to within about 18 seconds. Find the minutes in the first or third column and read the decimal hours beside it.

For quick reference, the quarter-hour values worth memorizing are 15 minutes = 0.25, 30 minutes = 0.50, 45 minutes = 0.75 and 60 minutes = 1.00. Every 6 minutes equals exactly 0.1 hours, which is why some employers track time in tenths of an hour.

Converting hours and minutes step by step

1. Write the time as hours and minutes, for example 8 hours 20 minutes.
2. Divide the minutes by 60: 20 ÷ 60 = 0.3333.
3. Round to the precision your payroll uses, usually two decimals: 0.33.
4. Add the whole hours: 8 + 0.33 = 8.33 decimal hours.

To go the other direction, multiply the decimal part by 60. For 8.33 hours, 0.33 × 60 = 19.8, which rounds to 20 minutes. Because of rounding, converting back can land a minute off, so keep the original clock times as the record and treat the decimal as a calculated figure.

Converting a whole shift: clock-in to clock-out

Most people need a full shift, not just a stray number of minutes. Subtract the start time from the end time, subtract any unpaid meal break, and then convert. For example, a shift from 8:47 a.m. to 5:18 p.m. with a 30-minute unpaid lunch is 8 hours 31 minutes on the clock, minus 30 minutes, which is 8 hours 1 minute of paid time. That is 8 + 1/60 = 8.02 decimal hours.

Overnight shifts (see overnight shift hours) work the same way, but you must add 24 hours to the end time when it falls on the next calendar day. A 10:00 p.m. to 6:30 a.m. shift is 8 hours 30 minutes, or 8.50 hours. For a full week, convert each day first and then add the daily decimals, or add the hours and minutes first and convert once. Either method gives the same answer apart from rounding, but adding minutes first and converting once introduces the least rounding error.

Turning decimal hours into pay

Once time is in decimal hours, gross pay is hours multiplied by the hourly rate. Eight hours and 31 minutes is 8.52 hours (31 ÷ 60 = 0.5167, shown as 0.52). At $18.00 an hour that is 8.52 × 18 = $153.36 before taxes and deductions. If you used the wrong shortcut and read the time as 8.31 hours, you would calculate $149.58, which is $3.78 too low for a single day. Over a five-day week that error would be almost $19.

Overtime uses the same decimals. If a worker logs 42 hours 45 minutes in a week, that is 42.75 hours. Under the federal Fair Labor Standards Act, covered non-exempt employees must be paid at least one and one-half times the regular rate for hours over 40 in a workweek, so 2.75 hours are overtime. At $20.00 an hour, regular pay is 40 × 20 = $800.00 and overtime is 2.75 × 30 = $82.50, for a total of $882.50. You can check your own numbers with the Overtime Pay Calculator. For the full method, see how to calculate overtime pay.

Rounding: what employers may and may not do

Decimal hours force a rounding choice, and rounding is regulated. For quarter-hour rounding in particular, see time clock rounding and the 7-minute rule. Under the U.S. Department of Labor's rule at 29 CFR 785.48(b), an employer may round clock punches to the nearest five minutes, the nearest tenth of an hour, or the nearest quarter hour, provided the practice averages out so that employees are fully compensated over time for all the time they actually work. In practice, that is where the familiar "7-minute rule" comes from for quarter-hour rounding: minutes 1–7 round down and 8–14 round up.

What matters is that the rounding is neutral. A policy that always rounds in the employer's favor, such as dropping every partial period, can result in unpaid work time and may violate wage laws. Note that rounding applies to the recorded start and stop times; it is not permission to ignore work performed before or after a shift. See what counts as hours worked for how pre-shift and post-shift tasks are treated. Some states have their own rules on rounding and on how the time must be recorded, so check your state labor department if you suspect a systematic shortfall.

Common mistakes to avoid

• Reading 7.30 as 7 hours 30 minutes. It is 7 hours 18 minutes.
• Rounding each punch up or down in the employer's favor instead of rounding neutrally.
• Rounding the decimal too early. Keep extra digits (for example 0.1667) until the final total, then round once.
• Forgetting to subtract an unpaid meal break before converting. Only bona fide meal periods in which you are completely relieved of duty can be unpaid.
• Mixing formats in a spreadsheet. Spreadsheet time cells store a fraction of a day, so multiply by 24 to get decimal hours.

Using spreadsheets and payroll software

In Excel or Google Sheets, a time such as 8:31 is stored as a fraction of a day. To convert it to decimal hours, multiply the cell by 24 and format the result as a number rather than a time. A formula like =(B2-A2)*24 returns the decimal hours between a start time in A2 and an end time in B2. Subtract the break in the same unit, for example =(B2-A2)*24-0.5 for a 30-minute unpaid lunch. If the shift crosses midnight, use =MOD(B2-A2,1)*24 so the result does not go negative.

Many payroll systems let an administrator choose whether hours are stored in hours:minutes or in decimals, and whether to round to hundredths. If your paycheck shows a number of hours that does not match your own records, ask your employer or payroll provider which format and rounding rule they apply before assuming an error. Keeping your own record of start and stop times makes it easy to reconcile the two.

This guide is for general informational purposes only and is not legal, tax, or financial advice. Labor laws vary by state and change over time. Confirm your specific situation with your employer, HR department, or the U.S. Department of Labor.