Skip to content

Instantly share code, notes, and snippets.

@CLOUGH

CLOUGH/gist:d744ffb33c13b391f537

Created January 26, 2016 21:03
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save CLOUGH/d744ffb33c13b391f537 to your computer and use it in GitHub Desktop.
Save CLOUGH/d744ffb33c13b391f537 to your computer and use it in GitHub Desktop.
Download ZIP
Excel formula creating a unix timestamp from a date and time cell.
Raw
gistfile1.txt
=IFERROR((P2+N2- DATE(1970,1,1))*86400,0)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment