Date to Unix time stamp?

N

Newbie

I have dates that I need to convert to a Unix timestamp.

Ex:
Date: October 20, 2003
Unix time stamp: 1066460400
 
J

JE McGimpsey

Unix timestamps are the number of seconds after 1/1/1970 00:00:00, so

A1: 10/20/2003
A2: =(A1-DATE(1970,1,1))*86400 ===> 1066608000


Note that your example would be incorrect:

B1: 1066460400
B2: =DATE(1970,1,1) + B1/86400 ===> 10/18/2003 07:00:00

not 10/20/2003
 

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

Unix Time Stamp? 3
Date Time Stamp formatting 5
update time stamp / date modified 3
Save As macro with date/time stamp 2
Displaying Unix time as date and time 1
time stamp 3
date without timestamp 2
How to apply sort by date when using FTP listdirectory .net 2.0 1

Top