Time calculation

[Anonymous]

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!

[Anonymous · Accepted solution]

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