JetMc!!!!

WOW!!!

I'm so impressed and even more GRATEFUL. THANK YOU!!! I have a huge smile on my face!

This works great.
One problem.

The problem is this, for example:
If you change P2 holiday to 9/28/16,
Then as expected, 'peak hours' changes from 2 to 1 - correct.
And total duration remains correct, at 15 hours.
However, 'non-peak hours' becomes 7.
But that is incorrect, because non-peak hours are defined as (5pm-on for M-F, weekends, and holidays) = 14 in this case.
Because your 'peak hours' formula is so AWESOME, I think the solution for defining non-peak hours
will simply be 'total duration' - 'peak hours.'

I will have to run more test cases, but this is looking great.
I can't thank you enough!!