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.;
if end_time - start_time < 0 then time_difference = end_time - start_time + '24:00:00't;
else time_difference = end_time - start_time;
if end_time - start_time < 0 then time_difference = end_time - start_time + '24:00:00't;
else time_difference = end_time - start_time;
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
Check out this tutorial series to learn how to build your own steps in SAS Studio.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.