Hello,

Any suggestions for a formula that would take military time living in cell A2 and assign it to one of the categories below?

4:00 - 11:59 = morning
12:00 - 16:59 = afternoon
17:00 - 21:59 = evening
22:00 - 3:59 = night



Thanks for the help!