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?

See a couple of answers in the .misc group.


Please don't post the same message to multiple groups. It tends to
fragment any answers you get, and it potentially wastes the time of
those posting solutions that have already been provided.

For tips on using these groups effectively, see

http://cpearson.com/excel/newposte.htm


In article <[email protected]>,
"jnorton" <[email protected]> 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?

=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:

> 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?
>