How to convert time to decimal in Excel

Microsoft Excel is one of the most optimal and indispensable calculation software on each person's computer. When using this software, users will be provided with many different types of functions, helping their calculations to be completed quickly and easily.

In the calculation process, sometimes we have to convert time into numbers, to do this in addition to performing the value conversion operation, we can also use some basic functions of Excel . Here we invite you to follow the article instructions on converting time to decimal numbers in Excel .

Download Microsoft Office 2016 Download Microsoft Office 2019

1. How to convert time by calculation in Excel

To be able to implement this method you first need to remember the unit of time and date conversion as:

• 1 day = 24 hours.
• 1 hour = 60 minutes = 3,600 seconds.
• 1 minute = 60 hours.

Step 1: First, open up the value table you want to convert and click on any empty cell.

Step 2: Enter the formula: = + "Value to convert" * 24 , in the value cell in the hour column.

Step 3: To perform the remaining columns you also enter the following formula:

• Minutes column: = + "Value to convert" * 24 * 60 .

• Second column: = + "Value to change" * 24 * 3600 .

Step 4: Finally, after performing the formulas we will get a table of values ​​as follows: 

2. Use the CONVERT function to transfer time in Excel

The CONVERT function is a function used to convert the values ​​of measurement units. To convert time to decimal using this function, we perform the following steps:

Step 1 : Click on any empty cell in the value table.

Step 2: Enter the formula: = CONVERT ("Value", "from_unit", "to_unit") . Inside:

• CONVERT: is the name of the function.
• Value: Number to transfer.
• From_unit: Unit of original number. 
• T o_unit: Units to be converted.

Units of conversion:

• day: unit is day.
• hr: units are hours.
• mn: unit is day.
• sec: units are seconds.

Note: In this article, From_unti will be "day" and convert time to number of hours / minutes / seconds, we replace the units in To_unti as "hr / mn / sec" respectively .

Step 3: Do the same with the remaining cells in each value column, finally we will get a table of values ​​as below:

Above are some ways to convert time to decimal in Excel, we hope that these things will help you can easily and quickly complete your work.

In addition, you can also refer to some articles such as: 

• Instructions to hide formulas in Excel .
• How to get the integer part of a number in Excel .
• Instructions for rounding whole numbers in Excel .
• Instructions for using Name Box in Excel .
• How to change uppercase and lowercase letters in Excel .

I wish you successful implementation!