Dear expert,
I would greatly appreciate it if someone else could assist me with this complex calculation.
I am attempting to calculate the 8 business hours from the creation date and hour of record, taking into account the exclusion of time for the weekends, holidays, and within business hours
Example1
Start Date & Time: 01/03/2024 08:00:00 AM
Desired Due Date: 01/03/2024 16:00:00 PM
Example2
Start Date & Time: 01/03/2024 11:00:00 AM
Weekends: Saturday and Sunday
Holiday = 04/03/2024
Desired Due Date: 05/03/2024 09:00:00 AM
Working hours: 08:00 AM to 18:00 PM
Holidays: (I have a list of holidays) for the test we can consider 04/03/2024
Business Days: Monday to Friday
Weekends: Saturday and Sunday