how to exclude hoidays and weekends on sla

Retrieve the Start Date:

• Capture the date and time when the notification event starts (this will be your start date for calculating the SLA).

Define the Working Hours:

• Determine the official working hours in your system (e.g., 9 AM to 5 PM).
• Assume a 5-day workweek (Monday to Friday).

List of Holidays:

• Create a list of holidays in your system (this can be stored in a database or hardcoded depending on your application).

Break 72 Hours into Working Days:

• Split the 72 hours into multiple workdays, accounting for working hours (e.g., if you have 8 working hours per day, then 72 / 8 = 9 full working days).

Iterate Over Calendar Days:

• Loop through the days starting from the notification event's start date.
• Skip weekends and holidays.
• Count only the workdays, and for each day, track the time worked towards the SLA.

Check if SLA Expires within Working Hours:

• As you add workdays and hours, check if the total reaches 72 hours within working hours on a particular day.