topic Re: get the minutes between two times in QlikView

get the minutes between two times

Mon, 10 Nov 2014 09:23:01 GMT

Hello!

Probably an easy one, I have two times, 08:30 and 08:40 and want to get the minutes between, 10 minutes in this case. How ca I calculate that in an expression?

Best regards

Mårten

Re: get the minutes between two times

MarcoWedel — Mon, 10 Nov 2014 09:25:27 GMT

(Time2-Time1)*1440

Re: get the minutes between two times

senpradip007 — Mon, 10 Nov 2014 09:26:47 GMT

Use interval( A-B, 'mm' ) where A = 08:40 and B = 08:30 will return 10.

Re: get the minutes between two times

PrashantSangle — Mon, 10 Nov 2014 09:27:31 GMT

Hi,

USe interval()

like interval(time2-time1,'hh:mm')

Regards

Re: get the minutes between two times

jagan — Mon, 10 Nov 2014 09:36:23 GMT

Hi,

Try like this

=Interval(Timestamp#('08:40', 'hh:mm') - Timestamp#('08:30', 'hh:mm') , 'm')

To get this in script try like below

Data:

LOAD

Interval(Timestamp#(Time2, 'hh:mm') - Timestamp#(Time1, 'hh:mm') , 'm') AS DiffInMinutes

FROM DataSource;

Hope this helps you.

Regards,

jagan.

Re: get the minutes between two times

aveeeeeee7en — Mon, 10 Nov 2014 09:42:52 GMT

Use Interval Function:

=Interval('08:40'-'08:30','mm')&' ' &'minutes'

Result is as follows:

Hope that helps you.

Regards

Av7eN

Re: get the minutes between two times

its_anandrjs — Mon, 10 Nov 2014 09:48:16 GMT

Hi,

Interval function is best for minute difference if the records in the same field then use Peek function to find that

LOAD

Time#( TimeField,'hh:mm' ) as TimeField, Interval(TimeField - Peek('TimeField'),'mm') as Diff,

LOAD * Inline

[

TimeField

08:30

08:40

];

If not then simple use

Time#(Time1,'hh:mm' ) as Time1,Time#(Time2,'hh:mm' ) as Time2,

Interval(Time2 - Time1,'mm') as Diff2;

Regards

Anand

Re: get the minutes between two times

MK_QSL — Mon, 10 Nov 2014 10:02:11 GMT

=Interval(Time#('08:40','hh:mm')-Time#('08:30','hh:mm'),'mm')

Re: get the minutes between two times

Mon, 10 Nov 2014 10:02:39 GMT

Thanks all!

Re: get the minutes between two times

senpradip007 — Mon, 10 Nov 2014 10:06:53 GMT

Welcome!!!!!!!!!!!!!!