Many times I have had to ask what portion of this date range was non-work time.

This does indeed vary by geography so we have added gmt start and end for each holiday.

We then have to handle four cases to determine the overlaps so the function has to sum the time from UNION ALL of the cases.

I can post this function if anyone is interested but if there is a better way please let me know.