Unix Time Stamp?

P

Pete_UK

If your Excel date is in A1, put this in B1:

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

Hope this helps.

Pete
 
R

Ron Rosenfeld

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate Holiday 2
Selecting Last Record 5
Date / Time problem 4
Creating custom stamps in .pdf Adobe documents 1
Date to Unix time stamp? 2
time stamp question 2
Date stamp user 7
plotting certain x points from a large data group 1

Top