0 Replies Latest reply: Sep 25, 2012 7:55 AM by and.akerman RSS

    Adding intervalls to total time

      Hi

      I have a problem trying to add different intervalls to a total amount of time. Im suspecting i have to use INtervallmatch somehow.


      I have the following:

       

      BlackoutID   Customer ID  START                          STOP                              Total time

      1                       A                2012-01-01 12:30      2012-01-01 14:00                    1:30

      1                       B                2012-01-01 15:00      2012-01-01 16:00                    1:00

      .                        .                                   .                         .                                         .

      2                       A                 2012-01-01 15:00      2012-01-01 16:00                   1:00

      .                        .                                   .                                                           

      .                        .                                   .

      .                        .                                   .

      5                       A                 2012-01-01 18:30      2012-01-02 18:00                   23:30

      5                       B                 2012-01-02 14:30      2012-01-03 07:00                   16:30

      ...                        ...               ...                                   ...                                             ...

       

      If the time between Different BlackoutIDs but the same Customer ID is less than two hours, i would like the total time to be added up.

      Example: Blackout iD=1 and Customer A has a blackout from 2012-01-01 12:30 to 14:00, total 1:30. but Blackout ID=2 and customer A has blackout from 15:00 to 16:00 the same day.I would then like to combine these two blackouts to one blackout starting 2012-01-01 12:30 to 16:00, total time 3:30. Is this possible?

       

      I have QV 10.

      Thx in advance!
      //Andreas