topic Time Difference in hh:mm using Interval function between two DateTimes in QlikView

Time Difference in hh:mm using Interval function between two DateTimes

narband2778 — Mon, 14 May 2018 11:58:50 GMT

Hello Qliks,

I am trying to find time difference in hh:mm from MinDateTime to MaxDasteTime

Ex: Interval('07/02/2018 13:14:00' - '07/02/2018 14:30:00', 'hh:mm')

I am looking for an output: -00:46

but, I am getting below result: -73894114:46

How can I resolve this.

Thanks in Advance.

Naresh

sunny_talwar — Mon, 14 May 2018 12:07:42 GMT

How are you getting -00:46? why not 1 hour and 16 minutes here?

This gives me 1:16

=Interval(MakeDate(2018, 7, 2) + MakeTime(14, 30) - MakeDate(2018, 7, 2) - MakeTime(13, 14), 'hh:mm')

YoussefBelloum — Mon, 14 May 2018 12:09:34 GMT

Hi,

the above gives you 01:16

this : =Interval('07/02/2018 13:14:00' - '07/02/2018 14:30:00', 'hh:mm') will give you -00:46

also, you should evalute and format your timestamp fields as Timestamps using Timestamp#() and Timestamp()