topic Re: Time calculation in QlikView https://community.qlik.com/t5/QlikView/Time-calculation/m-p/1188531#M886925 <HTML><HEAD></HEAD><BODY><P>Well, I found the solution.</P><P></P><P>If someone needs the answer it´s very simple.</P><P></P><P>In fact, 00:51 is in 24/12/1999, and of course, the 16:00 is in 23/12/1999.</P><P></P><P>So simple, I just did (Date_Arrival+Hour_Arrival)-(Date_Departure+Hour_Departure)</P><P></P><P>But if someone has a more beautiful solution please let me know <IMG src="https://community.qlik.com/legacyfs/online/emoticons/wink.png" /></P></BODY></HTML> Tue, 20 Sep 2016 13:35:04 GMT Anonymous 2016-09-20T13:35:04Z Time calculation https://community.qlik.com/t5/QlikView/Time-calculation/m-p/1188530#M886924 <HTML><HEAD></HEAD><BODY><P>Hello everybody!</P><P></P><P>I have a simple question.</P><P></P><P>I need to calculate the time of departure minus the time of arrival.</P><P></P><P>So, my time departure is 16:00 and my time of arrival is 00:51.</P><P></P><P>When I try Interval(Arrival-Departure) it gives me back -15:19.</P><P></P><P>How can I have the good result? so 8:51</P><P></P><P></P><P>Thank you very much!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Time-calculation/m-p/1188530#M886924 Anonymous 2020-11-25T16:16:04Z Re: Time calculation https://community.qlik.com/t5/QlikView/Time-calculation/m-p/1188531#M886925 <HTML><HEAD></HEAD><BODY><P>Well, I found the solution.</P><P></P><P>If someone needs the answer it´s very simple.</P><P></P><P>In fact, 00:51 is in 24/12/1999, and of course, the 16:00 is in 23/12/1999.</P><P></P><P>So simple, I just did (Date_Arrival+Hour_Arrival)-(Date_Departure+Hour_Departure)</P><P></P><P>But if someone has a more beautiful solution please let me know <IMG src="https://community.qlik.com/legacyfs/online/emoticons/wink.png" /></P></BODY></HTML> Tue, 20 Sep 2016 13:35:04 GMT https://community.qlik.com/t5/QlikView/Time-calculation/m-p/1188531#M886925 Anonymous 2016-09-20T13:35:04Z