While reading an Excel file into SPSS v.11.5 as a database query, everything
works fine except for a column/variable showing the Time of day for each
record, in the form....
10:28 PM, etc.
SPSS reads the Time in as a Date field format, all with the following date in
1899 followed by the correct time, extended with 00 seconds, as in....
30-DEC-1899 10:28:00, etc.
I've transformed the times in Excel into military time and read the file into
SPSS again to no avail, as I still get the same result. I'd appreciate any
advice how to get the original Time data in SPSS with an AM / PM indicator --
even military time and retaining the seconds would be OK, just not the 1899