Hourly Schedule Report

[snod2024]

I have a list of start and end times for employees and trying to create a visual report in excel. Is there any way to put a "X" or change cell color if times are within the range.

Please see attached for what I am trying to do.

If you would have a better idea of a report that would be appreciated as well.

[samba_ravi]

see the attached file