Excel if conditions with multiple criteria with dates for result hit or miss

I want formula for the conditions of three cells result hit or miss

help me out i have enclosed excel sheet.


If zone a then if start date before 10:00:00 am till same day before (23:00:59) 11:01 pm is result "hit" if condition not met under criteria result is "miss".
If zone a then if start date after 10:00:00 am till another day before (23:00:59) 11:01 pm is is result "hit" if condition not met under criteria result is "miss".