I am using Microsoft Excel- 2007 and need to calculate the total WORK-hours (09:00-17:30) between two date/time-stamps; Including Saturdays but excluding Sundays & Holidays
If we see below example then total hrs should be 01:00:00 hr only as call received time is after shift hours i.e. 06:30 PM

issue received time in Cell - A1=6/28/2013 6:30:00 PM
issue acknowledge time in Cell - A2=6/29/2013 10:30:00 AM

DayStart= 9:30:00 AM - Cell D1

DayEnd= 5:30:00 PM - Cell D2

HolidayList= "07/01/2013" – Cell D3

Please share the formula to use for above scenario. Thanks for the help!