Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Time calculation

Hello everybody!

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!

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

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

1 Reply
Anonymous
Not applicable
Author

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