Tools / Time and payroll

Decimal hours converter

Payroll and invoices want 7.75, the timesheet says 7:45. Type either one.

Decimal hours
7.75
Minutes
465

Do it in a spreadsheet

=A2*24
  • A2 a time such as 7:45

How it works

A spreadsheet stores a time as a fraction of a day, so 7:45 is 0.3229. Multiplying by 24 turns it into hours. Format the result cell as a number, not a time. To go back, divide decimal hours by 24 and format the cell as [h]:mm.

More time and payroll tools

Free, from Producfy

Get the next guide before you need it

One email when a new guide or tool goes up: working formulas, queries and scripts for spreadsheets, SQL and the CRM and billing exports that end up in them. At most one a week.

Esc