Create a gist now

Instantly share code, notes, and snippets.

Excel / Open Office timestamp conversions.
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