Starttime in a1
Endtime in b1
Working hours 08:00 to 18:00
Holidays list in d1 to d10
Weekend Sunday only

Formulas so far read from this forum is not
Addressing a solution if the end time
Falls on holiday/weekend

Start time is 24/12/2012 12:30 pm
End time is 25/12/2012 10:30 am

I should get answer as 8.00 hours

Any help pl??