Time Transform

[Mahbub Khandoker-2]

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