Date:         Thu, 1 Sep 2005 08:42:16 -0500
Reply-To:     "Peck, Jon" <peck@spss.com>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         "Peck, Jon" <peck@spss.com>
Subject:      Re: Excel time 8:46 becomes 8:45:99 in SPSS
Comments: To: Martin Sherman <MSherman@loyola.edu>
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.

-----Original Message-----
From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU] On Behalf Of Martin Sherman
Sent: Wednesday, August 31, 2005 8:45 PM
To: SPSSX-L@LISTSERV.UGA.EDU
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
8:45:99?

martin sherman