Excel Formulas to Convert Decimal Seconds into Excel Time!!

Have you ever tried to convert a number of seconds into hh:mm:ss time format in Excel? In this article, I will talk about some tricks to convert the decimal seconds into time format in Excel. Let’s get into the article!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

Generic Formula:

• You can use the below formula to convert the seconds into time format.

=Seconds/86400

Syntax Explanations:

• SECOND – The SECOND function in Excel returns the seconds from a time value.
• Seconds – It represents the input decimal seconds from your worksheet.
• Division (/) – It is used for dividing values or numbers.

Practical Example:

Refer to the below example.

• Suppose you have the following number of seconds in a Column and you have to convert them into hh:mm:ss format.

• Enter the above-given formula to the cell where you want to display the result.

• After that, press the ENTER key, it will display the result as shown in the below image.

Wrap-Up:

Hope you understood how to convert decimal seconds into Excel Time format. Explore more articles on Excel Date & Time. Please feel free to state your queries in the comment box below. We will assist you.

Thank you so much for visiting Geek Excel!! If you want to learn more helpful formulas, check out Excel Formulas *!! *

Read Ahead:

• Excel Formulas to Convert Decimal Minutes into Excel Time!!
• Excel Formulas to Convert Decimal Hours into Excel Time!!
• How to Find the Actual Price of the Discounted Price in Excel 365?
• Excel Formulas to Convert Date into Text ~ A Complete Guide!!