Excel Formulas to Convert Decimal Seconds into Excel Time!!
Tags: excelformula, excelformulas
Published: 2021-05-06 02:10:07

---
title: Excel Formulas to Convert Decimal Seconds into Excel Time!!
published: true
date: 2021-05-05 06:56:50 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/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](https://www.microsoft.com/en-in/microsoft-365/excel)

[![Convert decimal seconds into excel time](https://geekexcel.com/wp-content/uploads/2021/05/Convert-decimal-seconds-into-excel-time.png)](https://geekexcel.com/excel-formulas-to-convert-decimal-seconds-into-excel-time/convert-decimal-seconds-into-excel-time/#main)<figcaption id="caption-attachment-35731">Convert decimal seconds into excel time</figcaption>

## Generic Formula:

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

**=[Seconds](https://geekexcel.com/how-to-use-second-function-in-microsoft-excel-365/)/86400**

## Syntax Explanations:

- **SECOND** – The [**SECOND function**](https://geekexcel.com/how-to-use-second-function-in-microsoft-excel-365/) 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.

![Input Result](https://geekexcel.com/wp-content/uploads/2021/05/Input-Result.png)<figcaption id="caption-attachment-35733">Input Result</figcaption>

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

![Enter the formula](https://geekexcel.com/wp-content/uploads/2021/05/Enter-the-formula-9.png)<figcaption id="caption-attachment-35732">Enter the formula</figcaption>

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

![Result](https://geekexcel.com/wp-content/uploads/2021/05/Result-8.png)<figcaption id="caption-attachment-35734">Result</figcaption>

## 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](https://geekexcel.com/)!!** If you want to learn more helpful formulas, check out [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!! **

### Read Ahead:

- **[Excel Formulas to Convert Decimal Minutes into Excel Time!!](https://geekexcel.com/excel-formulas-to-convert-decimal-minutes-into-excel-time/)**
- **[Excel Formulas to Convert Decimal Hours into Excel Time!!](https://geekexcel.com/excel-formulas-to-convert-decimal-hours-into-excel-time/)**
- **[How to Find the Actual Price of the Discounted Price in Excel 365?](https://geekexcel.com/how-to-find-the-actual-price-of-the-discounted-price-in-excel-365/)**
- **[Excel Formulas to Convert Date into Text ~ A Complete Guide!!](https://geekexcel.com/excel-formulas-to-convert-date-into-text/)**