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:
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🤓:
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.
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.
There you go, time (seconds) converted into decimal time.
So, it’s easy, isn’t it😉?
