Skip to content

Instantly share code, notes, and snippets.

@palashkulsh

palashkulsh/utc to date conversion in excel

Created May 7, 2020 06:33
Show Gist options
  • Save palashkulsh/ee4676c573c4fb3dc98b111f5c1d9293 to your computer and use it in GitHub Desktop.
Save palashkulsh/ee4676c573c4fb3dc98b111f5c1d9293 to your computer and use it in GitHub Desktop.
Download ZIP
utc date format to date excel date format in excel
Raw
utc to date conversion in excel
=DATEVALUE(LEFT(B3,10))+TIMEVALUE(MID(B3,12,8))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment