topic Interval Time between two times in QlikView

Interval Time between two times

Tue, 02 Dec 2014 20:16:35 GMT

I need to find the time lapsed between two times which are basically the start and end times, and display it(Table) in the "hhmmss' Format.
1. 12:55:54 PM

2. 12:59:45 PM

Re: Interval Time between two times

MarcoWedel — Tue, 02 Dec 2014 20:21:09 GMT

Interval(Time2 - Time1, 'hhmmss')

Re: Interval Time between two times

MarcoWedel — Tue, 02 Dec 2014 20:23:25 GMT

If your time fields are text, then

Interval(Time#(Time2, 'hh:mm:ss TT')-Time#(Time1, 'hh:mm:ss TT'),''hhmmss')

either in a straight table or in the load script as:

Interval(Time#(Time2, 'hh:mm:ss TT')-Time#(Time1, 'hh:mm:ss TT'),''hhmmss') as Interval

Re: Interval Time between two times

its_anandrjs — Tue, 02 Dec 2014 20:47:12 GMT

You can write like

LOAD

Time#(start,'hh:mm:ss TT') as start,Time#(end,'hh:mm:ss TT') as end,

Interval(Time#(end,'hh:mm:ss TT') - Time#(start,'hh:mm:ss TT'),'hh:mm:ss') as Diff;

LOAD * Inline [

start,end

12:55:54 PM,12:59:45 PM ];

Or you can direct use

Interval(Time#(end,'hh:mm:ss TT') - Time#(start,'hh:mm:ss TT'),'hh:mm:ss')

Interval(end - start 'hh:mm:ss')

Regards

Anand