Need to create a "shift" column from a time column
I have a column with the time (hh:mm) an interaction took place. I have another (currently blank) column for shift that I need to populate from the time.
The "shift" during which an interaction took place would be: 7Am-12:59PM as Day, 1-8:59PM as afternoon and 9PM-6:59AM as night.
I'm not sure where to start. How do I construct a formula that basically tells me If time is between 7:00AM and 12:59 PM mark this column Day? I'm guessing it's an IF statement but I don't know how to write the condition for between the 2 times and then populate the answer I need. This is what I tried but it came back Imparseable.
=IF([Combined time arrived]1,>7:00AM,<12:59PM,"Day"
Was also thinking maybe it should maybe be a Nested IF formula but when I tried to enter the Combined Time arrived the second time it bounced me out.
Any advice would be wonderful!!! Thank you!!