Working Hours - excluding weekends, holidays

Hi everyone,

I'm new to this forum so apologies if I don't explain myself very well.

There are many threads that I've been through but can't find anything that works for me.

I need to work out the number of working hours/minutes between two dates (see attached):
DATA tab:
A column contains start date
B column contains end date

VARIABLES tab:
B1 contains the start of the working day
B2 contains the end of the working day

I need to exclude Saturdays and Sundays and any holidays (listed on VARIABLES tab)

The start date/end date are not always within working hours. I still need to calculate the hours/minutes worked within working hours though.

I would appreciate any help you can give as this is driving me mad!

Thanks all.