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

Is there a function that can convert 4/21/2005 10:43 to unix time like
1116910800?