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 |
