5 Replies Latest reply: Apr 24, 2018 3:21 AM by Michele De Nardi RSS

    How to subtract between two times in qlik sense

    Shahzad Ahsan

      Hi Everyone

      I need to subtract between two time. Please see the table below

      The values in 'T2' shows hours and minutes. For example 8.50 shows 8 hours and 50 minutes. So the difference of T1-T2 should be 9 - 8.50

      and the result should be .10 that means the difference is 10 minutes.

       

      I need measure expression to calculate 'Result' field.

       

      T1T2Result
      98.500.10
      1211.300.30
      98.590.01
      1211.400.20
      63.452.15