subtracting two dates and times

[#1]

l would like to subtract 2 dates and times. What formula do l use in qlikview? Last drop departure date minus Last drop arrival date

Last Drop Arrival Date	Last Drop Departure Date
28/10/2015 06:15	28/10/2015 7:45
28/10/2015 07:30	28/10/2015 09:30
29/10/2015 09:50	29/10/2015 11:30
28/10/2015 21:00	29/10/2015 08:00

[#2]

Hi Nard;

l want to see difference in time, minutes

[oknotsen]

round(([Last Drop Arrival Date] - [Last Drop Departure Date]) * 24 * 60, 1)

[Anonymous]

Hi Moses,

Please see my post to get the interval in minutes

[MarcoWedel]

Hi,

one solution could be:

LOAD *,
    Interval([Last Drop Departure Date]-[Last Drop Arrival Date],'hh:mm') as Duration;
LOAD Timestamp#([Last Drop Arrival Date], 'DD/MM/YYYY hh:mm') as [Last Drop Arrival Date],
    Timestamp#([Last Drop Departure Date], 'DD/MM/YYYY hh:mm') as [Last Drop Departure Date]
FROM [https://community.qlik.com/thread/190047] (html, codepage is 1252, embedded labels, table is @1);

hope this helps

regards

Marco