Login  Register

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