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....
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"
)
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"
)