Skip to content

Instantly share code, notes, and snippets.

@mapkyca

mapkyca/gist:2008119

Created March 9, 2012 19:04
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 mapkyca/2008119 to your computer and use it in GitHub Desktop.
Save mapkyca/2008119 to your computer and use it in GitHub Desktop.
Download ZIP
Excel / Open Office timestamp conversions.
Raw
gistfile1.txt
DATE -> SECONDS
---------------
(CELL - DATE (1970,1,1))*86400
TIME -> SECONDS
---------------
CELL * 24*60*60
TIMESTAMP -> DATE/TIME
----------------------
CELL / 86400+25569
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment