HIGHLIGHTING WEEKEND CELLS IN A EXCELL SHEET

Hi JOHN_69 

With the help of conditional formatting, you can achieve your requirements.

1) Highlight the Weekend Cells
Suppose column A contains the dates, select all data in this column and use the below formula as a conditional formatting rule.

=OR(WEEKDAY(B1,2)=6,WEEKDAY(B1,2)=7)

2) Highlight the Non-business Hours
Suppose column D contains the times, select all data in this column and use the below formula as a conditional formatting rule.

=OR(TEXT(D1,"HH:MM:SS")<TEXT($G$1,"HH:MM:SS"),TEXT(D1,"HH:MM:SS")>TEXT($G$2,"HH:MM:SS"))

You may refer to the attached sample file for more clarity and understanding.

Please let me know if it works for you.

Thanks

Tauqeer