I am trying to generate the SLA breach report for a helpdesk.The SLA is 42 hours(working). I am trying to calculate the Network Days and Network Hours between two dates with times. I want to know how many business days and hours are between the two days.
- 'Case Open_Date' (A1)
- 'Case Close_Date.' (B1)
-'Difference Time' (E1)
Work Days = Monday to Friday
Work Hrs = 09:00 AM to 11:00 PM (no lunch break)
Date Received: dd/mm/yyyy hh:mm
Date Actioned: dd/mm/yyyy hh:mm
Response Time: d - hh:mm
Please help me out...