9 Replies Latest reply: Apr 4, 2012 7:23 AM by Jason Michaelides RSS

    stucked with a time formate

    Göran Hofstedt

      Hi

      I find qlikview a bit tricky with time and dates but hope (as always..) to get som help from you!

       

      I have a field wich are just 0.30 for 30 min, 0.01 for 1 min, 1.15 for 1 hour 15 min. The sum for 2 * 0.3 becomes 0.6. I need it to be 1.

       

      Is there two diffrent ways of doing this? beacuse I´m not absolutly sure but I don´t think it need to be 1 as in 1 hour / 60 min. The user knows that 1.15 equal to 1 hour 15 min.