Decimal hours converter

Timesheets and payroll often want 7.75 hours, not 7:45. Convert either way below.

How to convert minutes to decimal hours

Divide the minutes by 60 and add the result to the whole hours. 7 hours 45 minutes is 7 + 45 ÷ 60 = 7 + 0.75 = 7.75 hours. To go back, multiply the part after the decimal point by 60: 0.75 × 60 = 45 minutes.

A common mistake is to read 7.30 as “seven thirty”. In decimal hours, 7.30 is 7 hours and 18 minutes; seven and a half hours is 7.5.

Adding up a timesheet

Hours and minutes don’t add up like ordinary numbers: 7:45 + 8:20 is 16:05, not 15:65. Converting each day to decimal first makes the sum easy: 7.75 + 8.33 = 16.08 hours. Multiply by an hourly rate and you have the pay for those hours.

Quarter-hour rounding

Many employers and timesheet tools round to the nearest quarter hour (0.25). The converter above shows that figure too. Clockflux does the same when it shows your daily totals in decimal, so 7 h 50 min appears as 7.75. See tracking your hours.

Decimal hours in Excel and Google Sheets

Spreadsheets store a time as a fraction of a day, so 7:45 is really 0.3229. Multiply by 24 to get decimal hours, and divide by 24 to go back. With a time in cell A1:

• Time to decimal hours: =A1*24, with the cell formatted as a number (7:45 → 7.75).
• Decimal hours to time: =A1/24, with the cell formatted as [h]:mm (7.75 → 7:45).
• Rounded to the nearest quarter hour: =MROUND(A1*24, 0.25).
• Hours between a start in A1 and a finish in B1: =(B1-A1)*24, or =MOD(B1-A1, 1)*24 for a shift that ends after midnight.
• A week’s total: =SUM(A1:A7), formatted as [h]:mm; the square brackets let the total go past 24 hours.

For a whole week of start and finish times with breaks, the time card calculator does the sums for you.

Minutes to decimal hours chart

More free tools