I need to handle the calculation of due dates with weighing segments
I try to explain better:
I have two time periods:
Day Time: 9AM-6PM
Night Time: 0AM-9AM and 6PM-0AM, plus all holidays
The service targets is: 9hrs
Service avalability: H24 without Pending periods.
Formula to build Due Date:
"Day Time" + 0.5 "Night Time"
Seconds spent during the night time hours must be weighed 0.5.
Issue Opened: 6PM
Due Date OOB= 5PM+ 9hr = (1hr Daytime) + (8hr NightTime) = 2AM (next day)
Custom Due Date: (1hr Daytime) + [(8hr remaining)] --> (7.5hr Night Time + 0.5 DayTime) = 9.30 AM (next day)
Have you got advice, how to manage this custom calculation? Regards