Help - formula(s) for showing hours between start/stop (Novice user)

I've been tasked with showing employee schedules by half-hour. I have the start time (e.g 8.5 or 8:30a) and the duration (8 hours) I've been asked to count all employees in each half hour, if they are working. So if an employee starts at 8:30 and works until 4:30 they would show as working for each half hour between 8:30 and 4p. Ideally a 1 would noted in every half hour between the times, so it can easily by summarized.

Any suggestion on what functions could be used or how this could be done? Here is an example of 1 record

Hi where is the example?

Example.xlsxThanks so much for the assistance. Attached is one set of records for an employee,and I have a 168 more datasets just like it.

Thank you

Can I just ask something, you want to count how many 1/2 hrs that person has worked? per day? then you sum the total at the end?

ExampleEndResult.xlsx

Yes, but need to show each half hour noted as 1 if they are working. Attached is the example with added end result needed

Thank you. This works great, however still have one small issue. When the start time is on the quarter hour, for example 11.25 or 11:15, a 1 needs to be in the 11am interval, The formula puts a 1 in the next interval. Is there a way to change it?

Thanks again for the help.