Excel formula if conition formula for 2 condition with consider timings

Hi dude

i need urgent help of excel function formula if condition result hit or miss

i have enclosed excel sheet

"1 st condition is if start time less than 10:00:00 am end time is another day before 23:00:00.
If its true result = ""hit project"", other wise ""miss""
should consider saturday ,should not consider sunday.(mon-sat)"

"2 nd condition is if start time greater than 10:00:00 am end time is another 2 day before 23:00:00 if its true result = ""hit project"", other wise ""miss""
should consider saturday ,should not consider sunday.(mon-sat)"