Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Convert Time (military and 36hours)

HI all,

I have 2 different fields, as an example:

One shows a correct time of 00:05   (12:05 AM)

The other shows 24:05 (12:05AM)

This field could and does show every time of day, up to and including 28:00 (04:00).

For all intents and purposes, even though a 28:00 is the next day, my other field is just showing 04:00 with no day marker, so I want these two fields to be the same (day can be dropped). 

I then want a field which will calculate the difference between the two fields. and for that to show up as number of hours and minutes.

For example.

15:00 and 25:15      would be a difference of -10:15 hours. However, with the formula you provide the 25:15 will be converted to 01:15

15:00 and 01:15      need a calculation for the difference between these, which is 13 hours 45 minutes (13:45)

Thanks for your help

1 Reply
MVP
MVP

Re: Convert Time (military and 36hours)

This should transform your 25:15 to 01:15:

Time(Frac(Interval#('25:15','hh:mm')),'hh:mm')

Community Browser