Custom column

[Babycakes]

Hi All 

I am attempting to get this custom column in Power Query however not quite correct

= Table.AddColumn(#"Changed Type1", "Rate", each if [Shift Start] < #time(18, 1, 0) then "Evening Rate"

 if [Shift end] > #time(18, 0, 0) then "Day Rate" else if [Shift End] < #time(18, 1, 0) then "Evening Rate"

If [Shift Start] < #time (05,59,0) then "Evening Rate" else ifIf [Shift Start] < #time (06,00,0) then "Day Rate"

and if [Shift Start] > #time (05,59,0) then "Evening Rate" else null)

else if [Shift Finish] > #time(18, 1, 0) then "Evening Rate" else null)

Shift Start	Sleepover Start	Sleepover Finish	Allocated Shift Break (mins)	Shift Finish	Worked Hours in Day	Shift Splits	Total shift hours	Week	Day
9:15 AM			0	1:15 PM	4.00		4	1	Thursday
9:15 AM			0	1:15 PM	4.00		4	2	Thursday
9:00 AM			0	1:00 PM	4.00		4	1	Tuesday
9:15 AM			0	1:15 PM	4.00		4	1	Wednesday

[lbendlin]

Your sample data doesn't match your description.  Please check, and please also indicate the expected outcome based on the sample data.