Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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')
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()