http://stackoverflow.com/a/26315881 =DATEVALUE(MID(A1,1,10))+TIMEVALUE(MID(A1,12,8))
Created
November 4, 2016 20:26
-
-
Save gowon/6c1f992b295c0ee88a9b7e883ddc26cc to your computer and use it in GitHub Desktop.
Parse ISO 8601 format date in excel with formula
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment