Convert seconds to time format in Excel and Google Sheets

=A2/(24*60*60) OR =A2/86400

=TEXT(A2/(24*60*60),"hh:mm:ss") // to store result as a TEXT value

=TEXT(A2/(86400),"hh:mm:ss") // to store result as a TEXT value

A2 = data cell

Check below for a detailed explanation with pictures and how to use formulas in Excel and Google Sheets.