Unix Time Stamp?

  • Thread starter Thread starter Mish
  • Start date Start date
If your Excel date is in A1, put this in B1:

=(A1-DATE(1970,1,1))*24*60*60

Hope this helps.

Pete
 
What is forumual to convert a date (example: 8/6/09) to Unix Time Stamp?
Click to expand...

A Unix timestamp is the number of seconds since 1 Jan 1970 00:00:00 UTC

So to convert any particular date to Unix, you could use:

A1: date to be converted (UTC)

=(A1-DATE(1970,1,1))*86400

Format as General.

Of course, if your date input is in local time, and not UTC, you'd have to
add/subtract the difference from UTC to adjust it. So if local time is UTC - 4
hours, then:

=(A1+4/24-DATE(1970,1,1))*86400
--ron
 
Back
Top