Minutes to Decimal Hours Conversion Chart

The minutes-to-decimal formula

One hour contains 60 minutes, so a minute value becomes a fraction of an hour by dividing it by 60.

Decimal hours = minutes ÷ 60

For hours and minutes together:

Decimal hours = whole hours + (minutes ÷ 60)

Examples:

For instant conversion without the chart, use the Decimal Hours Calculator.

Minutes to decimal hours chart: 1–60 minutes

This reference table shows each minute value as decimal hours. The two-decimal column is useful for quick timesheet or payroll entry when that precision matches the system you use. The four-decimal column keeps more precision for spreadsheets and intermediate calculations.

Values worth memorizing: 15 minutes = 0.25, 30 minutes = 0.50, 45 minutes = 0.75, and 60 minutes = 1.00 hour.

Why 8:30 is 8.50—not 8.30

The colon in 8:30 means 8 hours and 30 clock minutes. The decimal point in 8.30 means 8 hours plus 30 hundredths of an hour.

Because 0.30 × 60 = 18 minutes, 8.30 decimal hours actually represents 8 hours 18 minutes. The correct conversion for 8 hours 30 minutes is:

8 + (30 ÷ 60) = 8.50

How decimal hours are used on timesheets and payroll

Hours and minutes are convenient for reading a clock. Decimal hours are convenient for arithmetic because pay, billing and project cost calculations can multiply a single number by a rate.

For example, if a timesheet shows 7 hours 45 minutes, the payroll-ready decimal is 7.75 hours. At an hourly rate of $20:

7.75 × $20 = $155.00

If you already have daily hours and minutes for a full week, the Payroll Hours Calculator converts each day and totals the week.

Convert minutes to decimal in Excel

If cell A2 contains only a number of minutes, divide it by 60:

=A2/60

If whole hours are in A2 and minutes are in B2:

=A2+(B2/60)

If A2 contains a real spreadsheet time such as 8:30, spreadsheets store that time as a fraction of one day. Multiply by 24 and format the result as a number:

=A2*24

Convert minutes to decimal in Google Sheets

The same formulas work in Google Sheets:

=A2/60 for a minute count, or =A2+(B2/60) when hours and minutes are stored in separate cells.

If a cell contains a true time value such as 7:45, use:

=A2*24

Format the result cell as a number rather than a time value if you want to see decimal hours.

Spreadsheet formula for clock-in and clock-out times

If clock-in is in A2 and clock-out is in B2, a same-day shift can be converted to decimal hours with:

=(B2-A2)*24

For a shift that may cross midnight, use MOD so the calculation wraps into the next day:

=MOD(B2-A2,1)*24

If unpaid break minutes are stored in C2:

=MOD(B2-A2,1)*24-(C2/60)

If you prefer not to maintain formulas, our Work Hours Calculator handles start time, end time and unpaid break minutes directly.

Should you round decimal hours?

Exact minute conversion and time-rounding are different operations. First convert the actual minutes by dividing by 60. Then apply only the rounding method required by the payroll, billing or timekeeping policy you are using.

For example, 8 hours 10 minutes converts exactly to 8.1667 hours before any policy-specific rounding. Do not assume a quarter-hour, tenth-hour or other rounding method unless that is the method you actually need.

Two decimals vs four decimals

Two decimal places are convenient for display, but many minute values do not convert to a terminating two-digit decimal. Twenty minutes, for example, is 0.3333… hours.

When accuracy matters across several rows, keep more precision during intermediate calculations and round the final value only when necessary. This reduces accumulated rounding differences.

How to convert decimal hours back to hours and minutes

Keep the whole-number hours and multiply only the decimal fraction by 60.

Minutes = decimal fraction × 60

Example: 7.75 hours:

0.75 × 60 = 45 minutes

So 7.75 decimal hours equals 7 hours 45 minutes.

For quick conversions in either direction, use the Hours & Minutes Calculator.

Common minutes-to-decimal mistakes

1. Dividing minutes by 100

Minutes are based on 60 per hour, not 100. Divide by 60.

2. Typing clock minutes after a decimal point

8h 45m is 8.75, not 8.45.

3. Rounding every daily value too early

Repeated early rounding can create a different weekly total than calculating with higher precision and rounding at the end.

4. Confusing a clock time with a duration

“8:30 AM” is a time of day. “8 hours 30 minutes” is a duration. Both can be represented in spreadsheets, but they are not the same type of value.

5. Forgetting unpaid breaks

Converting gross shift time to a decimal does not automatically make it net worked time. Subtract excluded breaks before producing the final worked-hours total.