5 Replies Latest reply: Nov 8, 2017 7:23 AM by Shahzad Ahsan RSS

    How to calculate sum of Time

    Shahzad Ahsan

      Hi Everyone

      I want to calculate Sum of Time Diff in KPI without using 'Duration' property. Please view snapshot.

      I am using this expression:

      Sum(IF(endtime>=starttime,

      Interval(endtime-starttime,'hh:mm'),TIME(Interval#('24:00','hh:mm')-Interval(starttime-endtime,'hh:mm'),'hh:mm')

      ))

       

      If I use number formatting as Auto it gives 0.68 i.e. wrong.

       

      I want the result without using Duration. I want the solution using Expression(Formula).

       

      Please help

      qliksense.jpg