IF statement by time range condition

[Andrew_na_lang]

Hi Guys,

I need help in categorizing the time into groups - morning, evening, and none. 

If time is from 9:00 AM to 7:59 PM = Morning
If time is from 10:00 PM to 8:59 AM = Evening
else, none. 

Thank you, guys!!

Best

 

[Andrew_na_lang]

Super! Thank you!!! @amitchandak 

[amitchandak · Accepted solution]

@Andrew_na_lang ,

Create a new  column like

Switch(True() ,

[Time] >=Time(9,0,0) && [Time] <time(20,0,0), "Morning",

[Time] >=Time(22,0,0) ||  [Time] <= time(9,0,0), "Evening",

"Other"

)