I’m trying to return a value of what shift a tech starts his day based on when he inputs his starting time.
If they start anytime between 4 am and Noon that is shift 1
If they start between 12:01 and 8PM that is shift 2
If they start between 8:01 PM and 3:59 am that is shift 3
Right now I have the below formula in, and it seems to work if I enter a time in for anything for shift 1 or 2, but for some reason I can’t get shift 3 to work.