Function Problems

How to Convert Hours, Minutes, and Seconds to a Decimal Number in Excel

Aamir Naveed Akram Oct 9, 2026 869 views

Question details

The user needs to convert a time value containing hours, minutes, and seconds into a single numeric value, such as decimal hours, for calculation purposes.

How to Convert Hours, Minutes, and Seconds to a Decimal Number in Excel

Product: Excel
Device & OS: not provided
Scenario: Calculating payroll or time durations where time data needs to be multiplied by an hourly rate, requiring the time to be in a decimal format rather than standard hh:mm:ss.
Observed behavior: Time values are displayed as hh:mm:ss or contain typographic errors like double colons (e.g., 12::34:56), preventing direct use in standard mathematical operations.

Before you start

Verify whether your target cells contain valid Excel time formats or text strings, as this will determine which formula you need to apply for an accurate conversion.

Solution 1Recommended

Convert a Valid Excel Time to Decimal Hours

Use this method if your time data is properly formatted as a valid Excel time (e.g., 12:34:56).

In Excel, time is stored as a fractional portion of a 24-hour day. To convert a standard time value into decimal hours, you simply need to multiply the time value by 24 and adjust the cell formatting.

Select a blank cell

Click on an empty cell where you want the converted decimal number to appear.

Enter the multiplication formula

Type =A2*24 (assuming A2 contains your time value) and press Enter.

Format as Number or General

Select the result cell, navigate to the Home tab, click the Number Format dropdown menu, and select either General or Number to display the decimal correctly.

Convert a Valid Excel Time to Decimal Hours

Format carry-over: Excel may automatically format your formula result as a Time (e.g., 12:00 AM). You must manually change the format to General or Number to see the decimal value.

Solution 2

Convert Text-Based Time with Double Colons

Use this method if your time data was imported or typed incorrectly as text containing double colons (e.g., 12::34:56).

Powerful Spreadsheet Tool

Easily Process Time Data in WPS Spreadsheet

WPS Spreadsheet fully supports advanced time and date functions, making it incredibly simple to convert, format, and calculate time values for payroll or scheduling without compatibility issues.

1. Open your data file: Launch WPS Spreadsheet and open the workbook containing your time data.
2. Apply the conversion formula: Click on an empty cell, input =A2*24, and press Enter.
3. Adjust the formatting: Select the result cell, go to the Home tab, and change the formatting from Time to General or Number.

Perfectly compatible with Microsoft Excel formulas and time formatsQuickly convert time to decimal values using basic operatorsEasily clean messy text data with built-in text functionsFree to use with a familiar, user-friendly interface

microsoft office alternative - wps office

Frequently Asked Questions

How do I convert Excel time to decimal minutes?

To convert a time value to total minutes, you need to multiply the cell by 1440 (which is 24 hours multiplied by 60 minutes). For example, use =A1*1440 and change the cell format to Number.

How do I convert Excel time to total seconds?

Multiply the time cell by 86400 (24 hours × 60 minutes × 60 seconds). Enter =A1*86400 in the formula bar, press Enter, and then format the output cell as General or Number.

Why is my converted time result showing as a time like '12:00 AM' instead of a decimal?

Spreadsheets automatically apply the formatting of the referenced source cell to the formula result. Since you are referencing a Time cell, it formats the output as Time. Select your result cell, navigate to the Home tab, and change the number format dropdown from Time to General or Number to reveal the decimal.

Excel & Data Problems