Question about creating a new column based on Shift Time

Question

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 Answer

Use following formula
if [Hours] &lt;= 8 then "Night" else if [Hours] &lt;= 15 then "Day" else "Evening"

Forum Discussion