Date: Thu, 1 Sep 2005 08:42:16 -0500
Reply-To: "Peck, Jon" <firstname.lastname@example.org>
Sender: "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From: "Peck, Jon" <email@example.com>
Subject: Re: Excel time 8:46 becomes 8:45:99 in SPSS
Content-Type: text/plain; charset="us-ascii"
Excel has many time formats, and it can deal with time or day or elapsed times in various ways. Matching these to SPSS time and date formats is a little tricky (questions like which day is midnight part of come to mind), but I do not see behavior like this. Check the format on the SPSS side in the Data Editor dropdown list for Type, or, better, in Define Variable Properties.
From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU] On Behalf Of Martin Sherman
Sent: Wednesday, August 31, 2005 8:45 PM
Subject: [SPSSX-L] Excell time 8:46 becomes 8:45:99 in SPSS
Dear List, Why would an excel time of 8:46 be inported in SPSS as