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/(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/(24*60*60)
=A3/86400
=TEXT(A2/(24*60*60),"hh:mm:ss") // result will be stored as a TEXT value
=TEXT(A2/(86400),"hh:mm:ss") // result will be stored as a TEXT value
A2 = date cell
C2 = cell formatted as a time
C3 = raw number
=A2/(24*60*60)
=A3/86400
=TEXT(A2/(24*60*60),"hh:mm:ss") // result will be stored as a TEXT value
=TEXT(A2/(86400),"hh:mm:ss") // result will be stored as a TEXT value
A2 = date cell
C2 = cell formatted as a time
C3 = raw number