if a timetag falls between 2 times then...

I tried all day long but seem to hit some issues here.


I need to lookup if a column of timestamps fall between 2 other timestamps and if so, match values that correspond to these timestamps and print specific columns. I have attached a sample spreadsheet - any help would be much appreciated. I did browse through other threads to tweak what has already been discussed but dont seem to find something that works.
Any help would be much appreciated.
thanks.