Skip to content

Instantly share code, notes, and snippets.

@mrcgrtz

mrcgrtz/timestamp2excel.txt

Created June 8, 2010 08:30
Show Gist options
  • Star 2 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mrcgrtz/429760 to your computer and use it in GitHub Desktop.
Save mrcgrtz/429760 to your computer and use it in GitHub Desktop.
Download ZIP
Formula to convert a UNIX timestamp (in cell A1) to Excel date format.
Raw
timestamp2excel.txt
=DATE(1970;1;1)+(LEFT(A1;10)/24/60/60)
@u01jmg3
Copy link

u01jmg3 commented Nov 22, 2018

=DATE(1970, 1, 1) + (A1 / 24 / 60 / 60)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment