convert sql date in excel...

[dlorenc]

Im confused..how do I convert a number that was imported from ms sql 2005...into its date format in excel?..

this sql statement: select actual_end_date,dateadd(s,Actual_End_Date,'19700101')

gives me:
actual_end_date (No column name)
1203693715 2008-02-22 15:21:55.000.

now I have: 1203693715, in an excel cell..and I know it should convert to 2/22/08...???...

 

[dlorenc]

boy was I confused...my formula was pointing to the wrong cell..*sigh*..here is my solution..

F8 = 1,203,693,715.0 # seconds from 1/1/1970

as excel dates work in days, the conversion is =+E13+(F8/(60*60*24))

where e13 is 1/1/1970 (or use the raw number (set to general instead of date): 25569
and F8 is my number of seconds...

result is 2/22/08 3:21 PM