Desktop productivity for business analysts and programmers

time difference on multiple day

Accepted Solution Solved
Reply
Super Contributor
Super Contributor
Posts: 318
Accepted Solution

time difference on multiple day

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.;

 


Accepted Solutions
Solution
‎10-23-2015 07:45 PM
Respected Advisor
Posts: 3,059

Re: time difference on multiple day

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

View solution in original post


All Replies
Solution
‎10-23-2015 07:45 PM
Respected Advisor
Posts: 3,059

Re: time difference on multiple day

[ Edited ]
if end_time - start_time < 0 then time_difference = end_time - start_time + '24:00:00't;
else time_difference = end_time - start_time; 
Super Contributor
Super Contributor
Posts: 318

Re: time difference on multiple day

Thanks SAS KIWI - it worked fine, appreciate your time
☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 339 views
  • 0 likes
  • 2 in conversation