Excel Formulas to Convert Excel Time into Decimal Seconds ~ Easy Tricks
Tags: excelformula, excelformulas
Published: 2021-05-06 13:16:34

---
title: Excel Formulas to Convert Excel Time into Decimal Seconds ~ Easy Tricks
published: true
date: 2021-05-05 11:12:07 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-convert-excel-time-into-decimal-seconds/
---

We have already learned how to **[convert decimal seconds into time format in Excel](https://geekexcel.com/excel-formulas-to-convert-decimal-seconds-into-excel-time/)**. Here we are going to see the simple formula to **convert the Excel time into decimal seconds**. Let’s get started!! 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 time to decimal seconds](https://geekexcel.com/wp-content/uploads/2021/05/Convert-time-to-decimal-seconds.png)](https://geekexcel.com/excel-formulas-to-convert-excel-time-into-decimal-seconds/convert-time-to-decimal-seconds/#main)<figcaption id="caption-attachment-35869">Convert time to decimal seconds</figcaption>

## General Formula:

- To convert a valid Excel time into decimal seconds, you can multiply by 1440. Use the below formula:

**=A1\*86400**

## Syntax Explanations:

- **A1**  – It represents the input time on your worksheet.
- **Multiplication (\*) **– In this symbol will multiply any two values or numbers.

## Example:

Let’s consider the below example.

- Here, we will enter the input times in **Column B**.
- Now we need to convert them into seconds.

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

- Select any cell and type the above-given formula.

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

- Finally, press  **ENTER**   to get the result out, if you need, drag the fill handle over range to apply the formula.

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

## Conclusion:

From this short tutorial, you can get how to **convert the Excel time into a decimal second**. If you have any **issue** regarding this article or any unresolved **query** , please **comment** 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 Also:

- **[Excel Formulas to Time into Decimal Hours ~ Easy Tutorial!!](https://geekexcel.com/excel-formulas-to-time-into-decimal-hours/)**
- **[Excel Formulas to Convert Decimal Minutes into Excel Time!!](https://geekexcel.com/excel-formulas-to-convert-decimal-minutes-into-excel-time/)**
- **[How to Count missing values in a list in Excel Office 365?](https://geekexcel.com/how-to-count-missing-values-in-a-list-in-excel-office-365/)**
- **[Excel Formulas to Convert Date into Month and Year ~ Simple Solution!!](https://geekexcel.com/excel-formulas-to-convert-date-into-month-and-year-simple-solution/)**