Before I transfer these excel files into SPSS, I need to convert string date and times in the following format:
"Sep 25 2001 9:00 PM" into a date and time that is recognized by excel.
I have so far divided the text into columns, and I can then concatenate them back together to form a date, but when the time is added it reports it in the fraction (e.g. for 9:00 PM = 21:00 = 21/24 hours in a day = 0.875) How can I make it NOT turn the time into a fraction?
I figured changing these into a date/time that is not string would be easier on the excel side than on SPSS as I am just learning SPSS. However, if anyone knows how to convert string date/times to a date/time that is recognized by SPSS, that would be A-OK, too!