How to add a Conditional Column in Power Query based on a Shift Pattern?

First step is to bring your data into usable format

 

and then you can add the column in the Faults table.

 

 

Note that I modified your sample data as it was missing the "before 7am"  scenario.