Categorize shifts based on time

[Sreesubin]

Hello,

I have a work item where I’m in need to mark or categorize the shift data based on times !

Say for eg :

6 AM - 01-30 PM = Morning shift
01.30 PM - 09.30 PM = Noon shift
09.30 PM - 06 AM = Night shift

My input data in A column would be
00:57 AM
13:47 PM

 

[Sreesubin]

Basically., my purpose is i need to categorise tickets that are created across the timings to map the morning or noon or night shift .

So I wanted to find a formula which can categorise the shift based on the timings mentioned above.