How to automatically chart 1 and 0's for roster times of employees in hourly overview

Dear Excel forum,

I've been browsing around for a solution but could't find one yet.

I'm struggling with attached sheet where I've put 1's when an employee is working for the given roster times between the hours 06:00 and 05:00 (operating hours) by hand.

Since this is alot of work and will have to do this for around 100 lines per day for 4 different weeks, an automatic way would really help me out.

Im using a Office365 proplus version of Excel on windows 10.

I really appreciate any help on this, hope somebody knows how to do this with a formula.

Best regards, Christiaan