Unix Time Function

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

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 <[email protected]>,
"jnorton" <[email protected]> wrote:

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

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