TimeSmart

Excel Time to Decimal Formula

Generate Excel formulas to convert time to decimal hours. Copy ready-to-use formulas like =A1*24 for your spreadsheets.

Excel Formula Generator

General Formula

For cells formatted as time (HH:MM:SS)

=A1*24

Where A1 contains your time value

Specific Value Formula

Based on your input above

=TIME(1, 30, 0)*24

Result: 1.5000 decimal hours

💡 How to use in Excel:

  1. Copy the formula above
  2. Click on the cell where you want the result
  3. Paste (Ctrl+V / Cmd+V) and press Enter

Related Tools

Convert Time to Decimal Hours

Convert time to decimal hours instantly. Free online tool to convert hours, minutes and seconds to decimal format for payroll and timesheets.

Convert Decimal to Time Format

Convert decimal hours back to time format. Enter decimal like 1.75 and get 1 hour 45 minutes. Free decimal to time calculator.

Payroll Hours Calculator

Calculate work hours in decimal format for payroll. Enter start time, end time, and hourly rate to get total pay instantly.