If you want to convert the time into decimal seconds, you have come at the right place😎!

Let’s take an example to elaborate the procedure for how it’s done:

seconds in decimal format to Excel time

As you can see in the image above, we have seconds which we need to convert in decimal time.

Before we begin, there is something important that you should know. 24 hours a day has in total 86400 seconds. This information is being given because whenever we deal with conversion of time, we convert it by taking the 24-hour measurement.

Now, let’s begin with the same🤓:

seconds in decimal format to Excel time

Step 1: Analyze the issue and Input the formula accordingly

As every formula begins with an equal to sign🤷, so we will be inputting the same first, then we will be selecting the Seconds i.e. the time that we need to or want to convert in decimal format.

So, as per the example above, the Seconds are 60 i.e. cell C4.

seconds in decimal format to Excel time

Then we will divide the same by the 86400 (24 hours converted in seconds).

Step 2: Cross- check the formula and proceed

And that’s it, the overall formula is as follows:

=C4/86400 i.e. the time (seconds) in hand divided by 86400 (24 hours).

Please note: As the time is given in seconds, so we need to divide the same by the value in seconds only, if it would have been given in minutes or hours then the value so divided with it would have been minutes or hours as well.

seconds in decimal format to Excel time

There you go, time (seconds) converted into decimal time.

seconds in decimal format to Excel time

So, it’s easy, isn’t it😉?