Calculating an end date to be within business hours
Hi
The project that i am working on is on IT Calls that are logged. Depending on their priority, they need to be completed during business hours. (see below)
Priority
Business Hrs to Resolve
3
12 hrs
4
24 hrs
5
40 hrs
I need to calculate the End Date & Time of the Call which needs to be within business hours. My business hours is as follows:
Monday to Friday from 8:00 to 17:00 . Weekends and Public holidays are excluded. Below is a list of public holidays.
01-Jan
21-Mar
27-Apr
01-May
16-Jun
09-Aug
24-Sep
16-Dec
25-Dec
26-Dec
I have attached a sample list of Calls logged, its priority and business hours for Call to be closed.
Please can you assist.
Please note a call can be logged out of business hours (ie on weekends and after 17:00, however they only allowed to be solved within business hours)
Just following up, did you have a look at your scripting. By the way, your scripting works perfectly, except when it falls on the weekend, which gives the TargetResolveDateTime on a Sunday.
