topic Re: Time Difference in QlikView

Time Difference

Sat, 09 Aug 2014 05:49:17 GMT

Hi All,

I have two Fields start Time and End Time.i need to find the the difference between the Time in HH:MM:SS format. But the fields are not in the Time format(ie. if it is 10:16:25,then the field contains the value as 101625). How can I achieve the same. pls suggest.

Thanks in Advance.

Re: Time Difference

MK_QSL — Sat, 09 Aug 2014 05:54:34 GMT

=Interval(Time(Time#([End Time],'hhmmss'),'hh:mm:ss') - Time(Time#([Start Time],'hhmmss'),'hh:mm:ss'),'hh:mm:ss')

Re: Time Difference

PrashantSangle — Sat, 09 Aug 2014 07:01:35 GMT

Hi,

Try like this,

In script format it like

date(date#(startTime,'hhmmss'),'hh:mm:ss') as new_StartTime,

date(date#(endTime,'hhmmss'),'hh:mm:ss') as new_EndTime

Then use formula

like Interval(new_EndTime-newStartTime,'hh:mm:ss')

Or If you dont want to do in script level

then

=Interval(date(date#([End Time],'hhmmss'),'hh:mm:ss') - date(date#([Start Time],'hhmmss'),'hh:mm:ss'),'hh:mm:ss')

Regards

Re: Time Difference

MarcoWedel — Sat, 09 Aug 2014 09:42:19 GMT

=Interval(Time#([End Time],'hhmmss') - Time#([Start Time],'hhmmss'),'hh:mm:ss')