Question about creating a new column based on Shift Time

[vandam2]

I have a column in PowerQuery listing the hours in the day (1-24)

i would like to add a column that has three shifts based on  hours in day ,

1. Hours between 0-8 would be 'Night'

2. Hours between 8-15 would be 'Day'

3. Hours between 15 and 24 would be 'Evening'

not sure how to build a custom colum with the if statement to solve this issue

thank you 

[Vijay_A_Verma · Accepted solution]

Use following formula

if [Hours] <= 8 then "Night" else if [Hours] <= 15 then "Day" else "Evening"