Skip to content

Instantly share code, notes, and snippets.

@lucasrizoli

lucasrizoli/gist:1040285

Created Jun 22, 2011
Star
Embed
What would you like to do?
Learn more about clone URLs
Download ZIP
Convert UNIX timestamp to Excel date (in EST timezone)
Raw
gistfile1.txt
=(((A1/60)/60)/24)+DATE(1970,1,1)+(-5/24)
@lucasrizoli

This comment has been minimized.

Sign in to view
Copy link
Owner Author

@lucasrizoli lucasrizoli commented Jun 22, 2011

Taken from http://spreadsheetpage.com/index.php/tip/converting_unix_timestamps/
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment