3 Replies Latest reply on Apr 13, 2018 5:13 AM by Thorsten Lieder

    How to calculate a start- and end-time IN a time range?

    Thorsten Lieder

      Hi all,

       

      I have datapoints like this:

       

      start_timeend_time
      07:1507:26
      06:5008:04
      23:0001:05
      23:2000:20
      23:3500:50

       

       

      and a definded timetable, I can for example look with MAKEDATE(6:30,0), where I have to count, if the datapoints are IN this time-range:

       

       

      fromto
      05:3006:00
      06:0006:30
      06:3007:00
      07:0007:30
      07:3008:00
      08:0008:30
      08:3009:00
      09:0009:30
      09:3010:00
      10:0010:30
      10:3011:00
      11:0011:30

      ... and so an.

       

      How can I calculate, if this rows are IN this ranges?

      For example: the second row is IN 06:30 to 07:00, also IN 07:00 to 07:30, also 07:30 to 08:00, also 08:00 to 08:30

       

      Thank you very much for any note!!