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!
Bookmarks