18 Replies Latest reply: Feb 23, 2016 12:43 PM by Kim Goedmakers RSS

    calculating number of minutes between incoming hour and '16:15'

    Kim Goedmakers


      Hello,

       

      I am trying to calculate the number of minutes between an incoming timestamp e.g. '

       

      31-dec-14 08:05:00

       

       

      and the fixed hour '16:15'

       

      Defined some calculations in the load script:

       

       

          TIME("Sessie - OK zaal in tijdstip",'hh:mm:ss') as Time_in,

          MakeTime(16,15) as Cutoff_time,

          INTERVAL(MakeTime(16,15) - Maketime(10,15),'mm') as Interval_static,

          INTERVAL(MakeTime(16,15) - TIME("Sessie - OK zaal in tijdstip",'hh:mm:ss'),'mm') as Interval_dynamic,

          TIME(INTERVAL(MakeTime(16,15) - TIME("Sessie - OK zaal in tijdstip",'hh:mm'),'mm')) as Interval_dynamic_format

       

      Testresult "interval static" returns what I expected (240 min), but when trying to apply the same logic to my real time in, i am unable to get the correct answer.

       

      Any ideas on how to do this? Thanks for your help and time. Capture.PNG