Is there a function that can convert 4/21/2005 10:43 to unix time like 1116910800?
J jnorton May 24, 2005 #1 Is there a function that can convert 4/21/2005 10:43 to unix time like 1116910800?
J JE McGimpsey May 24, 2005 #2 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
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
J jnorton May 24, 2005 #3 =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
=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
