Forum Discussion
Solved
IF statement by time range condition
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
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"
)
2 Replies
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"
)
Super! Thank you!!! amitchandak
