0 Replies Latest reply: Jun 20, 2013 9:34 AM by Marcos Azevedo RSS

    Grouping by continuous dates

      Hi !
      I have a table like this:

       

      StepStartEnd
      Step 116/06/2013  09:01:4316/06/2013  09:11:17
      Step 216/06/2013  09:11:1716/06/2013  09:16:29
      Step 316/06/2013  09:16:29

      16/06/2013  10:47:30

      Step 416/06/2013  11:05:2016/06/2013 11:05:45
      Step 516/06/2013 11:05:4516/06/2013 11:14:09

       

       

      In the LOAD process I would like to finish with this:

       

      TimeStartEnd
      01:45:4716/06/2013 09:01:4316/06/2013 10:47:30

       

      Steps 4 and 5 are not selected because they sum less then 15 minutes.
      Is it possible to achieve this ?

       

      Thanks in advance !

       

      Regards,
      Itamar