Hi,
I was trying to get an answer to the below question but can't seem to figure it out and couldn't find anything similar to it.
I have to find out the date I can cancel an order based on specific rules.
Scenario: I have a order date of 22/12/2016 at 8:00am.
1. I need to know the latest date/time I can cancel this order before it exceeds our SLA.
2. It will need to calculate 34 business hours prior to the date/time of order.
3. Business hours are counted as M-F between 8am-5pm only. No weekends.
Ideally a VBA solution to calculate this would be good.
Thanks,
Mark
I was trying to get an answer to the below question but can't seem to figure it out and couldn't find anything similar to it.
I have to find out the date I can cancel an order based on specific rules.
Scenario: I have a order date of 22/12/2016 at 8:00am.
1. I need to know the latest date/time I can cancel this order before it exceeds our SLA.
2. It will need to calculate 34 business hours prior to the date/time of order.
3. Business hours are counted as M-F between 8am-5pm only. No weekends.
Ideally a VBA solution to calculate this would be good.
Thanks,
Mark