LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (September 2005)Back to main SPSSX-L pageJoin or leave SPSSX-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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


Back to: Top of message | Previous page | Main SPSSX-L page