Excel Date Time to Unix Time

[Guest]

I have a field in Excel which is formatted as 4/21/2005 10:43
I am uploading this feild into mysql I need the datetime to be converted to
unix time
like 1116910800 any ideas?

 

[Bob Phillips]

=TEXT( A1*86400-DATE(1970,1,1)*24*60*60,"0000000000")

I have texted it as it is too long for an Excel number display

 

[JE McGimpsey]

Unix time is the number of seconds after 1 January 1970. XL stores times
as fractional days, so you need to mutiply that elapsed time by
(60*60*24) or 86400.


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

Though your example Unix time is

05/24/2005 05:00:00

 

[JE McGimpsey]

????

It's only 10 digits.