Calculating time diff in Qlikview

[svante]

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_Arr1

I would appreciate a "TimeDiff" function!

Regards

[#2 · Accepted solution]

Use the Interval() function

Interval(arrival_loop1 - departure_loop1, 'hh:mm:ss')

[svante]

Big THX!! More elegant solution.

[hubertdudek]

This solution will crush when departure is exactly at midnight or after it as Svante used time not timestamp.