How to calculate time difference (minutes) in syntax?
Posted by rtdammann on Dec 09, 2013; 4:34pm
URL: http://spssx-discussion.165.s1.nabble.com/How-to-calculate-time-difference-minutes-in-syntax-tp5723526.html
The data comes as dd/mm/yyyy hh:mm in one column.
Opened_date = 7/2/2013 11:37
Closed_date = 7/8/2013 14:32
Compute days = CTIME.DAYS (Closed_Date - Opened_Date).
Execute.
Compute time = CTIME.MINUTES (Closed_time - Opened_time).
execute.
Compute daily_minutes = days*160. (because its a 9 hour day)
Compute abs_time = abs(time).
Execute.
COMPUTE Total_Minutes=Daily_Minutes + Abs_Time.
EXECUTE.
Any help would be appreciated.
Thanks
Ross