Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, this q has not been answered in this forum but many people must struggle with this:
Q: how to calculate time diff in script?
Ex Calc time between 2 loops. This is how I do it. Any comments and risk with this? I notcied that neg values doesnt go well, so u have to check for that or trust the data.
Time(Time(departure_loop1) - (Time(arrival_loop1))) as Diff_Dep1_Arr1I would appreciate a "TimeDiff" function!
Regards
Use the Interval() function
Interval(arrival_loop1 - departure_loop1, 'hh:mm:ss')
Use the Interval() function
Interval(arrival_loop1 - departure_loop1, 'hh:mm:ss')
Big THX!! More elegant solution.
This solution will crush when departure is exactly at midnight or after it as Svante used time not timestamp.