How to Convert Time to Decimal in Excel
Learn how to convert time to decimal in Excel with simple formulas, number formatting, and Google Sheets methods for payroll, billing, and spreadsheet calculations.
Works instantly in your browser.
Interactive Excel Time to Decimal Simulator
Enter any time value to see how common Excel formulas convert time to decimal hours in real time.
=A1*24
This is the easiest way to convert time to decimal in Excel because Excel stores time as a fraction of one full day.
=HOUR(A1)+MINUTE(A1)/60
Use this when you want to split the hour and minute parts before converting them into decimal hours.
=TEXT(A1,"[h]:mm")*24
Use this method when Excel totals can go beyond 24 hours. This page's live examples still assume standard HH:MM-style inputs.
Why Excel Converts Time as a Fraction of a Day
Excel stores time as a fraction of one full 24-hour day. That is why 12:00 is stored as 0.5 and 06:00 is stored as 0.25. To convert time to decimal in Excel, you need to turn that fraction into decimal hours before using the value for payroll, billing, or spreadsheet calculations.
The most common method is to multiply the Excel time value by 24. You can also use HOUR and MINUTE formulas or a format-safe formula for totals over 24 hours.
How to Convert Time to Decimal in Excel
Use these three methods based on the type of Excel time value you are working with.
Method 1: Multiply by 24
=A1*24
Use this when A1 already contains a standard Excel time value like 08:30. After entering the formula, format the result cell as Number or General.
Method 2: Split hours and minutes
=HOUR(A1)+MINUTE(A1)/60
Use this when you want a more explicit formula that shows how hours and minutes are converted into decimal hours.
Method 3: Handle totals over 24 hours
=TEXT(A1,"[h]:mm")*24
Use this when Excel totals or accumulated durations can go beyond 24 hours and you need Excel to keep counting hours correctly. This guidance applies to Excel formatting, not to the simplified demo inputs on this page.
Excel Time to Decimal Examples
Quick examples you can reuse in payroll sheets and spreadsheet calculations.
08:15 in Excel
08:15 × 24 = 8.25 decimal hours.
12:30 in Excel
12:30 × 24 = 12.50 decimal hours.
05:45 in Excel
05:45 × 24 = 5.75 decimal hours.
Convert Time to Decimal in Google Sheets
Google Sheets uses the same time logic as Excel, so you can also multiply a time value by 24 to convert time to decimal hours. This works for payroll sheets, timesheets, and billing templates.
Google Sheets formula
If A1 contains a time value such as 08:30, use this formula and format the result as Number.
Formatting tip
If the result still looks like time, change the output cell format to Number or Automatic with two decimal places.
Excel Time to Decimal FAQ
Answers to common questions about formulas, formatting, and spreadsheet time conversion.
Related Time Conversion Tools
Explore related tools for decimal hours, minute conversions, payroll workflows, and spreadsheet calculations.
Time to Decimal Converter
Convert hours and minutes into decimal hours for payroll and billing.
Decimal to Time Converter
Convert decimal hours back into standard hours and minutes.
Minutes to Decimal Chart
Check minute-to-decimal values quickly with a reference table.
Time Card Calculator
Calculate daily and weekly work hours for timesheets and payroll.
Need the main time to decimal converter too?
Go back to the main calculator to convert hours and minutes into decimal hours instantly for payroll, billing, spreadsheets, and work tracking.
Back to Time to Decimal Converter