convert time into text

[angelrun1]

I need to change a range of time (if between 05:00-11:00) into a text (morning) and/or if time is between 11:00-16:00 then it is afternoon and so on.

is it a simple if then?

 

[Jonmo1]

Welcome to the board.

You could use a nested IF setup, but a lookup would be better.

You need to clearly define all the ranges though

Night is say 10PM - 5AM
Morning is 5AM - 11AM
Afternoon is 11AM - 4PM
Evenening is 4PM to 10PM

Try
=LOOKUP(A1,{0,"05:00","11:00","16:00","22:00"}+0,{"Night","Morning","Afternoon","Evening","Night"})