topic Re: Caluculate the time diff bn two time stamps in App Development

Caluculate the time diff bn two time stamps

Kohli — Tue, 21 Dec 2021 20:08:52 GMT

I four columns in a Table. LIke

StartDate, StartTime, EndDate, EndTime

30/09/2018, 22:10:55, 01/10/2018, 00:55:23

01/09/2018, 15:10:55, 02/10/2018, 01:55:23

01/09/2018, 22:10:55, 02/10/2018, 15:55:23

03/09/2018, 15:10:55, 03/10/2018, 22:55:23

I want total journey in Minutes.

Re: Caluculate the time diff bn two time stamps

Gysbert_Wassenaar — Sun, 09 Dec 2018 08:15:59 GMT

Subtract the start date and time from the end date and time: EndDate+EndTime-StartDate-StartTime

Perhaps when you load the data you have to change text values into date and time values:

LOAD
    *,
    Interval(EndDate+EndTime-StartDate-StartTime,'mm') as JourneyInMinutes
    ;
LOAD
    Date(Date#(StartDate,'DD/MM/YYYY'),'DD/MM/YYYY') as StartDate,
    Time(Time#(StartTime,'hh:mm:ss'),'hh:mm:ss') as StartTime,
    Date(Date#(EndDate,'DD/MM/YYYY'),'DD/MM/YYYY') as EndDate,
    Time(Time#(EndTime,'hh:mm:ss'),'hh:mm:ss') as EndTime,
FROM
    ...source...

Re: Caluculate the time diff bn two time stamps

Kohli — Sun, 09 Dec 2018 10:10:07 GMT

Hello Gysbert,

Thank you for time spent.

I am getting null records with above formula.

Re: Caluculate the time diff bn two time stamps

Gysbert_Wassenaar — Sun, 09 Dec 2018 10:51:57 GMT

Then you need to find out what kind of data you're loading. Are they text values or are the numeric values?

Re: Caluculate the time diff bn two time stamps

Kohli — Tue, 11 Dec 2018 13:33:32 GMT

Only numeric values. There is no text values like Am and PM.

Re: Caluculate the time diff bn two time stamps

Gysbert_Wassenaar — Tue, 11 Dec 2018 16:44:30 GMT

That you don't see AM and PM does not mean that the values are numeric values. If I type 25 in this post it is text and not numeric. But if you're sure that they're numbers then I can't help unless you post a small Qlik Sense app with example data that exhibits the problem you describe. So, please post such an example .qvf file.

Re: Caluculate the time diff bn two time stamps

Kohli — Wed, 12 Dec 2018 05:46:18 GMT

Please find below XL file and calculate the time diff in Minuit's.