I'm making a work schedule in excel but I would like to make a graph or a
table showing we the employee works

Here is how the data looks like:
start end
name 7 am 5 pm

For the table would look like this:
7 am 8 am 9 am 10 am
name x x x x


I have tried if and or functions but it doesn't work.


Is there away to graph this or use functions to make this happen?

Thanks
Brandon