Hours to Decimal: Total Your Timesheet

How do I convert hours and minutes to decimal?

Split the time into hours and minutes, then divide the minutes by 60 and add them to the hours: 7 hours 45 minutes is 7 + (45 ÷ 60) = 7.75 decimal hours. The timesheet tool above does this for each row as you type — enter "7:45" or "7h 45m" and the decimal reading appears immediately, so you never have to run the division by hand for every entry on a timesheet.

How do I total a timesheet in decimal hours?

Convert every entry to decimal hours first, then add the decimals — never add clock times directly and convert the sum, because clock-time addition rolls over at 60 minutes and silently produces the wrong total (7:45 + 1:30 is not "9:75"). Enter each entry as a row in the timesheet above — 7:45, 1h 30m, and 0.25 all parse correctly — and the running total converts and adds as you go, with a billable amount at your rate underneath. That's the safest way to total a week: one conversion per entry, not one conversion at the end.

How do I convert time to decimal in Excel or Google Sheets?

If a cell holds a real time value (formatted as time, like 7:45), multiply it by 24 and change the result cell's format to Number: =A2*24. Excel and Sheets store time internally as a fraction of a 24-hour day, so 7:45 is stored as 0.322916…, and multiplying by 24 converts that fraction back into hours — 7.75. If the cell shows the correct time but the formula returns a tiny decimal like 0.32, the result cell is still formatted as time or a custom time format; switch it to Number or General and the 7.75 will show. To total a whole column of times, sum the time cells first with =SUM(A2:A10), then multiply that single total by 24 rather than multiplying each row individually.

Why does payroll use decimal hours?

Because decimal hours are ordinary base-10 numbers that arithmetic works on correctly, while clock time (h:mm) is base-60 and breaks standard multiplication and addition. Payroll and invoicing systems need to multiply hours by a rate — 7.75 hours × $75/hour is a straightforward $581.25, but "7:45" × $75 is meaningless without first converting it. Decimal hours also add cleanly across a timesheet (7.75 + 1.5 + 0.25 = 9.5) where clock times don't, which is exactly why the totals field in almost every payroll export, spreadsheet, and invoicing tool expects a decimal like 7.75 rather than a time like 7:45.

Related tools: convert a single value with the minutes to decimal converter, track time live and skip manual entry entirely with the billable timer, or turn a totaled timesheet straight into a bill with the invoice generator.