=DATEVALUE(MID(A1,1,10)) + TIMEVALUE(MID(A1,12,8))
Thanks to @rcoup on Stack Overflow
Last active
January 9, 2024 22:26
-
-
Save bww/9757080c1a0ebc5b7e4208f9514d5ce1 to your computer and use it in GitHub Desktop.
RFC 3339 date parsing in Google Sheets
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment