public
Last active

Excel / Open Office timestamp conversions.

  • Download Gist
gistfile1.txt
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

Please sign in to comment on this gist.

Something went wrong with that request. Please try again.