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.

Convert seconds to time format in Excel

How to convert seconds to time format in Excel?

CONVERT SECONDS TO TIME FORMAT — EXCEL FORMULA AND EXAMPLE

  1. =A2/(24*60*60)

  2. =A3/86400

  3. =TEXT(A2/(24*60*60),"hh:mm:ss") // result will be stored as a TEXT value

  4. =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

Convert seconds to time format in Google Sheets

How to convert seconds to time format in Google Sheets?

CONVERT SECONDS TO TIME FORMAT — GOOGLE SHEETS FORMULA AND EXAMPLE

  1. =A2/(24*60*60)

  2. =A3/86400

  3. =TEXT(A2/(24*60*60),"hh:mm:ss") // result will be stored as a TEXT value

  4. =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