Checking if time is between 2-4 hours after another time

[Lifeseeker]

Hello,

I would like to get some grip on the syntax of a formula in excel 2007.

Logic is I want C2 to = "yes" if

B2's time is between 2 and 4 hours after A2's time.

Any help is much appreciated.