Multiple Days Hourly staff count

I posted one before and had no luck. So i am posting again. I have racked my brain for about 5 days now and have gotten no where. I am able to get it to work for 1 day but i need it to work for multiple days (31) to exact. I have it so it will lookup the start date but having trouble lookuping up end date or the between times.

I want to be able to put in the person, position, date and time start in one cell and date and time end in another cell. The main tab then looks up all the data i enter and color codes it out as well as counts the number of staff at the bottom (i alread have done this)

Please help. I am using excel 2007

It is a big file but that is because of the code i already have in there to show what i want it to do.