I need to build a formula based on the start time, order type and business hours. start time and due time are datetime.
The difficult part about this is I need to calculate this around the business hours. Which means say I need to find the due date 2 days after today, then I need to consider the local business hours whether it will be a weekend and whether there will be a public holiday.
I haven't found related documents around this functionality. Is that doable via formula?