Hi All,
I want to add business hours to datetime field(Ticket_Raised) and my business hours are 08:00 to 17:00.
Few conditions we keep in mind:
1)If any ticket raised below 08:00 then we should consider that as 08:00 on same day
2) If any ticket raised after 17:00 then we have to consider ticket raised date as next day 08:00
3) Also we need to exclude week ends and Holidays from this
Please help....... Thanks in advance ..Below is the sample table:
Ex: Ticket_Raised BusinessHours TargetDate
2016-02-21 06:24:23:6754 24 ?
2016-04-15 18:23:12:9876 48 ?
2016-01-02 11:13:16:1483 12 ?