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 in Excel
CONVERT SECONDS TO TIME FORMAT — EXCEL FORMULA AND EXAMPLE
CONVERT SECONDS TO TIME FORMAT — EXCEL FORMULA AND EXAMPLE
=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
Convert seconds to time format in Google Sheets
How to convert seconds to time format in Google Sheets?Convert seconds to time format in Google Sheets
CONVERT SECONDS TO TIME FORMAT — GOOGLE SHEETS FORMULA AND EXAMPLE
CONVERT SECONDS TO TIME FORMAT — GOOGLE SHEETS FORMULA AND EXAMPLE
=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
Other useful DATE and TIME formulas in Excel and Google Sheets
- Combine date and time
- Convert date to text
- Convert time to text
- Convert 1-12 to month name
- Convert month name to number
- Convert date to month and year
- Convert numbers of days to year/month/day
- Dynamic current date and time
- Dynamic current time
- Dynamic today and yesterday date
- Convert number stored as a text to date
- Convert weekday string to number
- Sum by month
- SUMIF cells if contains part of a text string
- Sum total sales based on quantity & price
- Count blank cell
- Count cell between two values
- Combine two or more cell
- Extract left before first space
- Extract the nth words in a text string
- Flip the first and last name
- SUMIF formulas and example
- SUMIFS formulas and example
- COUNTIF formulas and example
- IF formulas and example
- TEXT formulas and example
- CONVERT formulas and example
- Change the negative number to zero
- Change negative to positive numbers
- Calculate percentage changes for containing zero or negative values
- Count cells over 10 characters
- Count cells that are not blank
- Count if cells contain a specific text
- Count cells that begin with a specific text
- COUNTIF based on multiple criteria