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
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>
| Time | Shift |
| 12:00 AM | |
| 1:00 AM | |
| 2:00 AM | |
| 3:00 AM | |
| 4:00 AM | |
| 5:00 AM | |
| 6:00 AM | |
| 7:00 AM | |
| 8:00 AM | |
| 9:00 AM | |
| 10:00 AM | |
| 11:00 AM | |
| 12:00 PM | |
| 1:00 PM | |
| 2:00 PM | |
| 3:00 PM | |
| 4:00 PM | |
| 5:00 PM | |
| 6:00 PM | |
| 7:00 PM | |
| 8:00 PM | |
| 9:00 PM | |
| 10:00 PM | |
| 11:00 PM |
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>
