I have a file that I would need to group the time into a specific shift. For example,
6.45am to 3.15pm falls under MORNING
3.15pm to 11.45pm falls under EVENING
11.45pm to 6.45am falls under NIGHT
I managed to separate the time from the existing datetime column. However, I'm stuck with the grouping using formulas.
Is it possible to group the time into specific shifts using formulas? Thank you!