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?
