Breaking down time of day into shifts
Hello,
I have time data that I would like to breakdown into shifts to analyze shift patterns
9:00PM-5:59AM = night shift
6:00AM-11:59AM = morning shift
12:00PM-8:59PM = afternoon shift
Can anyone provide any guidance on how to do this with a formula or script? I'm a beginner and am just using recode which is very slow.