topic Re: Calculating time diff in QlikView

Calculating time diff

Anonymous — Tue, 02 Jan 2018 06:03:59 GMT

Hi All,

How to Calculate time diff .

Ex: To-From as Duration

Thanks,

Krishna

amit_saini — Tue, 02 Jan 2018 06:11:30 GMT

PFA!

=interval(time([ To ], 'hh:mm:ss') - time([From ], 'hh:mm:ss'), 'hh:mm:ss')

Regards,

Anonymous — Tue, 02 Jan 2018 06:34:22 GMT

Hi Amit,

How to Calculate 24 - interval(time([ To ], 'hh:mm:ss') - time([From ], 'hh:mm:ss'), 'hh:mm:ss')

Thanks,

Krishna

amit_saini — Tue, 02 Jan 2018 06:42:48 GMT

Like this???

=interval(time('24:00:00', 'hh:mm:ss')-

interval(time([ To ], 'hh:mm:ss') - time([From ], 'hh:mm:ss'), 'hh:mm:ss'))

Thanks,