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

Esc