# 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