Unix Time Function

[Guest]

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

 

[JE McGimpsey]

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

 

[Guest]

=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