I have a column of date and time fields (e.g. "15/6/2021 11:35:22 PM"). I would like to display "Morning" if the field consists of time between 06:00:00 and 11:59:59 and display "Afternoon" if the field consists of time between 12:00:00 and 18:00:00.
I tried this but doesn't work: 
Is there any excel formula that can do this?
Appreciate any help!!
Aucun commentaire:
Enregistrer un commentaire