< Go Back

Convert decimal seconds to Excel time

This Excel tutorial shows how to convert decimal seconds to Excel time with simple steps and formula. Here, decimal seconds will be converted to the time recognized by Excel.

Converting decimal seconds to Excel time requires the division of the specified number of seconds by the total number of seconds in a day, which is the number of seconds in 24 hours, 60 minutes and 60 seconds. Multiplication of the hours, minutes and seconds in a day equates to 86400.

The formula to convert decimal seconds to Excel time

=seconds/86400

How to convert decimal seconds to Excel time?

Let’s consider the following steps to convert decimal seconds to Excel time.

  • Select a cell and input the specified number of seconds to be converted to Excel time.

Figure 1. Table showing the seconds to be converted to Excel time.

  • Insert the formula to convert decimal seconds to Excel time.

Figure 2. The formula to convert seconds into Excel time.

  • The results are displayed in decimal values.

Figure 3. The seconds are returned as decimal values.

  • The result is then formatted to time. To format the result as a time, Right click on the cell and select “Format Cells”.

Figure 4. The ‘Format Cells’ menu from the drop down after the right click.

  • From the ‘category’ list, select ‘Time’ and choose your desired time format.

Figure 5. Choose a desired Excel time format for the conversion of the decimal seconds.

  • The decimal values are now converted to the desired time format.

Figure 6. The decimal seconds to Excel time.

Notes

  • The shortcut to open the “Format Cells” dialog box: simply press the “Control” + “1” keys.
Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California

Leave a Comment

avatar