3 Replies Latest reply: Feb 5, 2010 12:44 PM by BitnByte RSS

    Divide time value with time value

    BitnByte

      Hi

      I am trying to divide one Time value with another Time value but QV retuns the wrong answer

      I use this expression in my calculation
      Time((sum(POPITI * DJMAQT)/1000)) / Time((max(DJRGDT_TM_Timestamp) - min(DJRGDT_TM_Timestamp) - sum(OprTime)))

       

       

      But if I split the 2 Time values different parst then I get the right answer
      Time((sum(POPITI * DJMAQT)/1000)) then will QV return -> 00:18:39 as expected
      and when I use
      Time((max(DJRGDT_TM_Timestamp) - min(DJRGDT_TM_Timestamp) - sum(OprTime))) then will QV return -> 01:06:15 as expected

      But when I try to divide the to fields in QV in one calculation then I get the wrong strange answer -> -0,006633...?!?

      The right decimal answer should be 00:18:39 / 01:06:15 > 0,281509 (tested in MS Excel)
      (the answer is an KPI figure count for our company)

      Thanx for any replies
      // Daniel