interval function giving negative results

[syed]

Dear qlikview experts

Iam struck with one issue

shiftid       shift in time  shift out time

         1        06:00:00       15:00:00

          2       09:00:00        18:00:00

          3       12:00:00         21:00:00

          4     15:00:00         00:00:00

when iam using interval function like interval(shift out time-shift in time ) i am getting total working hours for all shifts but for

shiftid 4 iam getting values in negative like -15:00:00. will any one please look in to this where Iam doing wrong.

Thanks

[jonathandienst · Accepted solution]

Hi

Shiftid 4 starts at 15:00:00 and finishes at 00:00:00 (value 0), so you need something more to calculate these times. If they are always less than 24 hours, this will work

     Interval(If([shift out time] > [shift in time], [shift out time] - [shift in time], 1 + [shift out time] - [shift in time]))

The '1' adds 1 day (24 hours) to the interval.

If they could be more than 24 hours, you will need start and end dates as well.

HTH

Jonathan

[syed]

Perefect John Its working now. Thanks alot