topic Re: time difference on multiple day in SAS Enterprise Guide

time difference on multiple day

woo — Fri, 23 Oct 2015 21:28:57 GMT

hello,

please help

Have start_time and end_time in date format and need difference in hh:mm:ss

have

start_time end_time

3:00:00 5:00:00

21:00:00 25:10:23

16:25:00 18:50:10

20:15:34 20:16:50

21:00:00 1:25:55 /*here end_time is next day time*/

want

time_difference

2:00:00

4:10:23

2:25:23

0:01:16

4:25:55

below logic is working fine but not for last record, it is giving negative number becasue end_time is in next day

time_difference=end_time-start_time;

format time_difference time8.;

SASKiwi — Fri, 23 Oct 2015 22:37:08 GMT

if end_time - start_time < 0 then time_difference = end_time - start_time + '24:00:00't;
else time_difference = end_time - start_time;

woo — Fri, 23 Oct 2015 23:45:19 GMT

Thanks SAS KIWI - it worked fine, appreciate your time