Illustration for Minutes to Decimal Hours: A Conversion Chart for Timesheets

Seven hours thirty minutes is not 7.30 hours. It is 7.5. That one slip is behind a lot of payroll errors, and it is easy to avoid once you see how the conversion works.

The formula

Decimal Hours = Hours + (Minutes ÷ 60)

There are 60 minutes in an hour, not 100, so the minutes have to be divided by 60 before they can sit after a decimal point.

8 hours 20 minutes = 8 + (20 ÷ 60) = 8.33 hours

6 hours 45 minutes = 6 + (45 ÷ 60) = 6.75 hours

Minutes to decimal chart

MinutesDecimalMinutesDecimalMinutesDecimal
10.02210.35410.68
30.05240.40420.70
50.08250.42450.75
60.10270.45480.80
100.17300.50500.83
120.20330.55540.90
150.25350.58550.92
180.30360.60570.95
200.33400.67601.00

The ones worth memorising are the quarter hours: 15 minutes is 0.25, 30 is 0.5 and 45 is 0.75. Every 6 minutes is one tenth of an hour.

What the mistake costs

An employee on $34 an hour works 7 hours 45 minutes. The correct pay is 7.75 × $34 = $263.50. Entered as 7.45, it comes out at $253.30, which is $10.20 short for one shift. Over a year of shifts that adds up, and underpayments have to be back-paid.

Going the other way

To turn decimal hours into hours and minutes, keep the whole number and multiply the decimal part by 60.

5.4 hours: 0.4 × 60 = 24, so 5 hours 24 minutes.

Adding up a week

Convert each day to decimal first, then add. Or add the hours and minutes separately and convert the total: 37 hours 150 minutes is 37 + 2.5 = 39.5 hours.

Skip the arithmetic: open the time to decimal calculator, then take the result to the pay calculator.