Discussion board where members can get started with QlikView.
I have a simple question.
I need to calculate the time of departure minus the time of arrival.
So, my time departure is 16:00 and my time of arrival is 00:51.
When I try Interval(Arrival-Departure) it gives me back -15:19.
How can I have the good result? so 8:51
Thank you very much!
Well, I found the solution.
If someone needs the answer it´s very simple.
In fact, 00:51 is in 24/12/1999, and of course, the 16:00 is in 23/12/1999.
So simple, I just did (Date_Arrival+Hour_Arrival)-(Date_Departure+Hour_Departure)
But if someone has a more beautiful solution please let me know
View solution in original post