Exclude weekends and public holiday with many conditions

[sora11]

Hi.

I have max expression with condition of specific time. But I also want to exclude Saturday, Sunday (Weekends)  and public holiday.

I already did this expression

=Max({$<Time = {">$(=('11:00'))<=$(=('12:00'))"},Time = {">$(=('14:00'))<=$(=('17:00'))"},CalendarDayName-={'Sat','Sun'} ,Date#-={'1/1/2017','5/1/2017','8/31/2017','9/16/2017','12/25/2017'}>}[Total kw])

But the result still not exclude Saturday, Sunday and public holiday.

Thanks in advance!

[Channa]

it is better to add Flag for Sat,Sun and PublichHolidays as "H"

[sora11]

Thank you so much Channa! I got it now