3 Replies Latest reply: Feb 24, 2014 7:07 AM by Stefan Fischer RSS

    Convert time string an round time

    Stefan Fischer

      Hi,

       

      i will convert date and time in the right format.

      strTime: 10.02.2014 07:45:50

       

      10.02.2014 -> Date(Left(strTime,10),'DD.MM.YYYY') AS DAT,

       

      07:45:50 -> Time#(Right(strTime,8),'HH.MM.SS') AS TIM

      or

      07:45:50 -> Time(Right(strTime,8)) as TIM

       

      Now, strTime should be round to next 10 min, e.g. 07:50:00. I've check a formula in excel, but in QlikView it's no working.

       

      07:50:00 -> RUNDEN(TIM*24/(1/6);0)*(1/6)/24

       

      Do you have any idea, whats wrong?

       

      Regards
      Stefan