Convert seconds to time

This tutorial shows how to convert seconds into time by using a basic arithmetic formula

Excel

EXCEL FORMULA 1. Convert seconds to time

EXCEL

Hard coded formula

Cell reference formula

=30/1440

=B5/1440

GENERIC FORMULA

=seconds/86400

ARGUMENTS
seconds: A number that represents seconds that you want to convert to time.

GENERIC FORMULA

seconds/86400

ARGUMENTS
seconds: A number that represents seconds that you want to convert to time.

EXPLANATION

This formula uses a simple arithmetic formula to convert seconds into time. It takes the seconds that you want to convert to time and divide it by the number of seconds in a day (86400). Please note that to show the time (results) longer than 24 hours you will need to apply the [h]:mm:ss format.

Click on either the Hard Coded or Cell Reference button to view the formula that has the seconds directly entered into the formula or referenced to a specific cell.

Related Topic	Description	Related Topic and Description
Convert hours to time	How to convert hours to time
Convert minutes to time	How to convert minutes to time
Add seconds to time	How to add seconds to time
Subtract seconds from time	How to subtract seconds from time