Excel Date Time to Unix Time
 

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?

=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

--
HTH

Bob Phillips

"jnorton" wrote in message
...
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?

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





In article ,
"jnorton" wrote:

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?

????

It's only 10 digits.


In article ,
"Bob Phillips" wrote:

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