Excel Query for converting time stamp into morning, afternoon, evening and night

[sd28649]

I have below excel sheet table and I want to convert the given time stamp into morning, afternoon, evening and night. time between 12 am to 11 am - morning, 12 pm to 3 pm- evening, 4 pm to 8 pm- evening, 9 pm to 11 pm- night. Please suggest

[TABLE="width: 128"]
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl67, width: 64"]Time[/TD]
[TD="class: xl67, width: 64"]Shift[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]12:00 AM[/TD]
[TD="class: xl65"] [/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]1:00 AM[/TD]
[TD="class: xl65"] [/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]2:00 AM[/TD]
[TD="class: xl65"] [/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]3:00 AM[/TD]
[TD="class: xl65"] [/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]4:00 AM[/TD]
[TD="class: xl65"] [/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]5:00 AM[/TD]
[TD="class: xl65"] [/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]6:00 AM[/TD]
[TD="class: xl65"] [/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]7:00 AM[/TD]
[TD="class: xl65"] [/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]8:00 AM[/TD]
[TD="class: xl65"] [/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]9:00 AM[/TD]
[TD="class: xl65"] [/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]10:00 AM[/TD]
[TD="class: xl65"] [/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]11:00 AM[/TD]
[TD="class: xl65"] [/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]12:00 PM[/TD]
[TD="class: xl65"] [/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]1:00 PM[/TD]
[TD="class: xl65"] [/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]2:00 PM[/TD]
[TD="class: xl65"] [/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]3:00 PM[/TD]
[TD="class: xl65"] [/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]4:00 PM[/TD]
[TD="class: xl65"] [/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]5:00 PM[/TD]
[TD="class: xl65"] [/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]6:00 PM[/TD]
[TD="class: xl65"] [/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]7:00 PM[/TD]
[TD="class: xl65"] [/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]8:00 PM[/TD]
[TD="class: xl65"] [/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]9:00 PM[/TD]
[TD="class: xl65"] [/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]10:00 PM[/TD]
[TD="class: xl65"] [/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]11:00 PM[/TD]
[TD="class: xl65"] [/TD]
[/TR]
</tbody>[/TABLE]