Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

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!

Tags (3)
1 Solution

Accepted Solutions
Highlighted
Contributor III
Contributor III

Re: Time calculation

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
Highlighted
Contributor III
Contributor III

Re: Time calculation

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