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!
Bookmarks