How do I get my formula to work in a power query

Hi everyone,

I'm trying to add a custom column in my query. The excel formula looks like this

IF(OR(HOUR([StartTime])=23,HOUR([StartTime])=24,HOUR([StartTime])<7),"3rd Shift",IF(AND(HOUR([StartTime])>7,HOUR([StartTime])<16),"1st Shift", "2nd Shift"))

But I know for a power query the syntax is different.

Can someone help me please.

Thank you,

-Justin