Date:         Thu, 11 Jun 2009 17:58:06 -0700
Reply-To:     Mahbub Khandoker <mk_spss@yahoo.ca>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         Mahbub Khandoker <mk_spss@yahoo.ca>
Subject:      Time Transform
Content-Type: multipart/alternative;

Hi there,
I have a excel data set with date and time variables. When I load the data in spss the date and time variables remain string. I am able to change the date to date format but I couldn’t able to change time in time format (hh:mm).
 
Could any one please let me know how I can change time variables in time format? I also want to calculate the time difference in hours by adding date and time. Please let me know how I can do that to.
Example
 
Arrival Date      Arrival Time     Leading Date Leaving Time       Time spent (in hours)




2008-04-12

1111

2008-04-12

1158
 
Thanks in advance.Mahbub



      __________________________________________________________________
Yahoo! Canada Toolbar: Search from anywhere on the web, and bookmark your favourite sites. Download it now
http://ca.toolbar.yahoo.com.
[text/html]