>Hmm, sounds familiar. Maybe this would help Re: How to get empty time between slots Message #674218.
>

Not exactly, because this problem is a little bit different. But could be a starting point, thanks.

>>Hi everybody,
>>
>>This seems like an interesting problem:
>>===========================================
>>ID.......StartDate............FinishDate
>>1 .......1/1/2003 07:30.......1/1/2003 08:00
>>2 .......1/1/2003 08:00.......1/1/2003 09:45
>>3........1/1/2003 15:00.......1/1/2003 15:30
>>
>>given an initial start date and finish, lets say all dates can range from 07:00 to 18:00 in one day.
>>
>>How could i produce results like:
>>
>>1/1/2003 07:00 - 07:30 - FREE
>>1/1/2003 07:30 - 08:00 - RESERVED
>>1/1/2003 08:00 - 09:45 - RESERVED
>>1/1/2003 09:45 - 15:00 - FREE
>>1/1/2003 15:00 - 15:30 - RESERVED
>>1/1/2003 15:30 - 18:00 - FREE
>>=======================================
>>Thanks in advance.