Created

Embed URL

HTTPS clone URL

SSH clone URL

You can clone with HTTPS or SSH.

Download Gist

Excel / Open Office timestamp conversions.

View gist:2008119
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
 
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
Something went wrong with that request. Please try again.