Skip to content

Instantly share code, notes, and snippets.

@jeansymolanza

jeansymolanza/dd-mm-yyyy hh:mm:ss excel conversion

Last active February 23, 2023 11:12
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 jeansymolanza/8a1967379050a23f4e7aab0ed1f8fb58 to your computer and use it in GitHub Desktop.
Save jeansymolanza/8a1967379050a23f4e7aab0ed1f8fb58 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
dd-mm-yyyy hh:mm:ss excel conversion
=DATE(RIGHT(B1,4),MID(B1,4,2),LEFT(B1,2)) + TIME(MID(B1,12,2),MID(B1,15,2),MID(B1,18,2))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment