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
A2a 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.