Can anyone help..
In cell A2 i have Received Date/Time, cell B2 Response Date/Time, work start at 9am (C2)and ends at 8pm (D2).
Received Date/Time 31/12/2009 9:00 AM
Response Date/Time 01/01/2010 10:00 AM
Work Day Start Time 9am
Work Day End Time 8pm
Working hours to resolve 12:00:00
i’m using =(NETWORKDAYS(A2;B2)-1)*(D$2-C$2)+IF(NETWORKDAYS(B2;B2);MEDIAN(MOD(B2;1);D$2;C$2);D$2)-MEDIAN(NETWORKDAYS(A2;A2)*MOD(A2;1);D$2;C$2) formula to get the resolve hours within the workdays (Mon – Fri), but it skipped the weekend.
if the request comes after working hours, i.e 8:30pm and solved next day at 9:30am the calculation should start at 9:00am next day and resolve time is 00:30:00(minus after office hours)
How to calculate the incoming case and resolve time on weekend as well because my team works 7 days a week.
