mercredi 7 juillet 2021

Excel formula If cell (that has date and time) contains a range of time, display return value

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: enter image description here

Is there any excel formula that can do this?

Appreciate any help!!

Aucun commentaire:

Enregistrer un commentaire