Skip to content

Instantly share code, notes, and snippets.

@matwerber1

matwerber1/google-sheet-formula-parse-iso86001-date-strings.md

Created July 30, 2022 03:28
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save matwerber1/7be956890c8937face20890b3dd57931 to your computer and use it in GitHub Desktop.
Save matwerber1/7be956890c8937face20890b3dd57931 to your computer and use it in GitHub Desktop.
Download ZIP
Google Sheet Formula to convert ISO86001 date from string to usable timestamp data type.
Raw
google-sheet-formula-parse-iso86001-date-strings.md

Google sheet formula to convert a ISO86001 string to a date time:

Input: 2022-06-23T16:31:34.036000+00:00 (cell A2)

Formula: SUM(SPLIT(left(A2,len(A2)-6),"T"))

Output: (a properly-formatted datetime)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment