Matching similar time frames between tables

Hi Mark.  They could be an hour, but could be several.  The providers are working with autistic clients that have different needs, so the times will vary.  They might be there for 2 hours, or it could be 5, etc.  It's an ongoing schedule every week.  They would go at the same time each week for the same amount of time.  Every morning at 9am till noon for instance.  The time frame is known, but varies between clients.  

I basically want to see which clients have time frames that fall within the providers time frame.  A provider may work from 9 to 5, but could have several clients.  One in the morning, one mid day, and one later.  A staff member would look at the potential clients and then manually decide if there is a good fit for the providers schedule. 

Thanks

------------------------------
Dana Hauser
------------------------------