how to exclude hoidays and weekends on sla

Question

made a application to send out notification with a 72 hours sla

Tuhin Paul · Answer

Steps to Implement SLA Exclusion of Holidays and Weekends: 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.

how to exclude hoidays and weekends on sla

Answers (1)