Skip to content

Instantly share code, notes, and snippets.

@doobee46

doobee46/google-sheets-unix-timestamp-formula.txt

Forked from simonw/google-sheets-unix-timestamp-formula.txt
Created April 25, 2020 13:00
Show Gist options
  • Save doobee46/2b1edb2e178dbca39197b3f57687cd98 to your computer and use it in GitHub Desktop.
Save doobee46/2b1edb2e178dbca39197b3f57687cd98 to your computer and use it in GitHub Desktop.
Download ZIP
How to convert a unix timestamp to a human-readable datetime string in Google Sheets
Raw
google-sheets-unix-timestamp-formula.txt
=((A1-21600000)/86400000)+25569
# Then select the column and use Format -> Number -> Date time
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment