Could you please help me with 3 and 4 on how to write the formula?

Help me IF function to mark violent inside crimes (Inside crimes with firearms) with "YES" in the "Violent Inside Crimes" column. For other crimes, put NA in the column. You need to pay attention that the content in the "Inside/Outside" column is not consistent.

4- Use IF function to create three categories for crime time (Midnight, Daylight, Evening) in the column "Crime Time Category" Midnight:

From 12 am to 6 am

Daylight: from 6 am to 6 pm

Evening: from 6 pm to 12 am