How to convert Time to Decimal numbers in Excel (Hours, minutes, and seconds)

Sometimes, you may need to store Time in Excel cells in decimal formats. Converting Time to decimal numbers is one of the most straightforward tasks in Excel. Several methods are used in converting Time to decimal numbers. This article will discuss common ways of converting Time to decimal number format.

Using Format Cell Tool

Steps:

1. Open the Excel application.

2. Add the Time that you wish to convert in decimals.

3. Select all the cells with the Time.

4. Right-click on the selected region, and choose the Format Cells option.

5. From the Format Cells dialogue box, click on the Number tab.

6. Locate the Category section, and click on the Number button.

7. Use the up and Down arrows to adjust the Decimal places. Then, click on the OK button.

Using the Arithmetic way

This is the easiest way to convert Time to decimal numbers in Excel. Here are the steps follow:

1. Open the Excel application.

2. Add the Time that you wish to convert to decimals.

Note: The cell that contains your Time should be in time format. To change the cell format, highlight the cells and right-click. Next, click the Format cells button, and select the Time option.

3. Locate three empty columns and name them, Hours, Minutes, and seconds respectively.

4. Highlight the three columns (Hours, Minutes, and seconds), right-click and select the Format Cells Button. Select the Numbers format.

5. In the Hour column, select the cell that contains the Time and multiply it by 24. For example, =A2*24.


6. Next, click on the empty cell in the minute column. Select the cell that contains the Time and multiply it with 1440. For example, =A2*1440.


7. Then, click the second column. Select the cell that contains the Time and multiply it with 86400. For example, =A2*86400.

Using the CONVERT function

Steps to follow:

1. Open the Excel application.

2. Add the Time that you wish to convert to decimals.

3. Locate three empty columns and name them, Hours, Minutes, and Seconds respectively.

4. In the Hour column, select an empty cell and type this function =CONVERT ({cell}, "day", "hr").


5. Next, click on the empty cell in the minute column. Select an empty cell and type this function =CONVERT ({cell}, "day", "mn").


6. Then, click the second column. Select an empty cell and type this function =CONVERT ({cell}, "day", "sec").


Using Hour/Min/sec functions

a) To convert to hours

Steps to follow:

1. Open the Excel application.

2. Add the Time that you wish to convert to decimals.

3. Locate another empty cell and type this formula =HOUR ({cell})+ MINUTE({cell})/60+ SECOND({cell})/3600.


4. Press the Enter key.

b) To convert to minutes

Steps:

1. Open the Excel application.

2. Add the Time that you wish to convert to decimals.

3. Locate another empty cell and type this formula =HOUR ({cell})*60+ MINUTE({cell})/60+ SECOND({cell})/60.


4. Press the Enter key.

c) To convert to seconds

Steps:

1. Open the Excel application.

2. Add the Time that you wish to convert to decimals.

3. Locate another empty cell and type this formula =HOUR ({cell})*3600+ MINUTE({cell})*60+ SECOND({cell}).


4. Press the Enter key.