Excel Formula: Convert Time to Decimal Seconds
This tutorial provides a formula for converting time to decimal seconds in Excel.
|Time: the excel time that is used to convert to decimal seconds.|
The formula returns a value in time format, then format the result as number as you need to get the decimal seconds.
How this formula work
Supposing in cell B3, there is a time value, to convert the time to decimal seconds, please use below formula:
Press Enter key to get a value in time format.
Click Home tab, and go to the Number Format drop-down list to choose General or Number to display the result as a number.
There are 24 hours a day, and one hour is equal to 60 minutes, one minutes is 60 seconds. To convert the time to decimal seconds, you should multiply the value 24*60*60.
- Convert Decimal Minutes to Time Format
This tutorial provides a formula to convert decimal minutes to Excel time.
- Convert Decimal Seconds To Time
To convert decimal seconds to Excel time in Excel, a formula can help you.
- Convert Time to Decimal Hours
Here provides a formula that converts time to decimal hours in Excel and explains how the formula works.
- Convert Time To Decimal Minutes
In this tutorial, it provides a formula for converting time to decimal minutes in Excel.
- Excel IF Function
Test for specified conditions, then returns the corresponding values
- Excel VALUE Function
Convert text to number.
- Excel MONTH Function
The MONTH is used to get the month as integer number (1 to 12) from date.
- Excel DAY Function
DAY function gets the day as a number (1 to 31) from a date
- Excel YEAR Function
The YEAR function returns the year based on the given date in a 4-digit serial number format.