# How To Convert Time To Decimal Hours/Minutes/Seconds In Excel?

If you’ve got a range of text or time using the the [HH:MM;SSi] formats in Excel And you’re looking to convert them into decimal hours, minutes , or seconds. How do you do it quickly? This tutorial will show some techniques to tackle this job.

## Convert Time To Decimal Hours/Minutes/Seconds With Formulas

In Excel In Excel, you can apply some formulas in Excel to convert [hh] [hh] [hh]to decimal hour, minute, or seconds.

1. Choose a cell, then enter the formula =A1*24 in it. Then press Enter to find the formula out. If you require to fill the handle, move it over area to apply the formula.

2. Right-click on the specified range, and select for Format Cells from the context menu. Then, in the pop-up dialogue choose Number from the category list and then select the decimal points you want to use. Check out the screenshots below:

3. Click OK. Then, each time is transformed to decimal hours in one go.

Tip:

1. You also can use this formula to convert time to hours =HOUR(A1)+MINUTE(A1)/60+SECOND(A1)/3600.

2. If you wish to convert time into decimal minutes, you can use this formula: A1*24*60 (or =HOUR(A1) * 60 MINUTE(A1) + SECOND(A1) 60.

3. If you are looking to convert time into decimal seconds, try this formula: A1*24*60*60, or =HOUR(A1) * 3600 * MINUTE(A1) * 60 SECOND(A1).

## Convert Time To Decimal Hours/Minutes/Seconds With Time Convert

If you don’t like formulas to remember You can use the the Convert Time software from Kutools on Excel for Excel to change time into decimal hours, minutes or seconds with a single click.

Once you have installed Kutools for Excel Follow the steps below:(Free download of Kutools for Excel Right Now! )

Choose the time period you wish to convert to decimal numbers, then click Kutools > Content > Convert Time and choose the option that you require by clicking the Context menu. Take a look at the screenshots below:

After you have selected the option to convert the dialog will pop up to remind you of how many cells were converted. Select “OK” to end the process.

You can now see that each second the conversion has been completed.

Note:

If you’d like to convert your time into decimal numbers and store the result in a different location it is possible to follow these steps:

1. Choose the data range, then select the data range and click Kutools > Content > Convert Time > Convert Time. Check out the screenshot:

2. In the pop-up dialog you will need to check the converting option you want to use in the Convert Type section. Check the Save to a different location(Convert range is a single area) checkbox. Click to choose a range that will show the result then click OK and OK to close dialogs. Check out the screenshots:

The data is then stored and converted in a different storage location.

## Convert Time To Decimal Hours/Minutes/Seconds With Super Functions

In reality, with Kutools for Excel it is possible to make use of Kutools Functions for Excel to translate decimal numbers into time.