Forum Discussion

Andrew_na_lang's avatar
Andrew_na_lang
Helper V
4 years ago
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....
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    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"

    )