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".

Hi excelhooker

Are you sure that you have written what you mean?

You refer to Zone A. Do you want anything other than Zone A to be a "Miss" ?

You refer to a start time of 10:00:59, but starting either side of this time gives the same result.

The result of the above means that the start time does not matter and the only thing that makes a difference is the end time.

An additional question - from what you have said, any activity ending the same day will be a miss. Is this what you want?

Regards
Alastair

I want result if Zone A and If Start Date/Time is Less than 10:01 AM If End Time is Less Than 11:00 PM Evening Same Day Is HIT If End Even One Min Greater then 11:01 PM is MISS.
Second Condition If Zone A and IF Start Date/Time is greater than 10:01 AM if End Time is Less Then 11:00 PM Till Next Day Evening is HIT if End Time Even Crossed ONe minute also MISS

Hi excelhooker

I must read more carefully! The "same" and "another" on your original posting appeared very close and I read it wrongly - my apologies. I will get on to this this weekend (but don't let that stop any one else replying)

Regards
Alastair

Hi excelhooker

I attach the spreadsheet. I have used several helper columns (mainly so I understand what is going on); these can either be hidden or put on another sheet. It is possible to write the formula without helper columns, but you get an extremely complicated formula!

Based on your example, line 8, I have worked on the premise that any entry that is not Zone A will be a "hit".

I hope that I have now got this correct, and that it is what you want. Let me know if I have misunderstood.

Regards
Alastair