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?

Excel Date Time to Unix Time
 

See a couple of answers in .misc

PLEASE don't post the same message to multiple groups. It tends to
fragment any answers you get, and potentially wastes the time of those
providing solutions that others have provided.

For tips on using these groups effectively, see

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




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?