Hello,

I have a need to calculate between two timestamps, measuring whether a contractual service delivery committment is made, and whether the request is received during business hours or after hours, changes when the required completion timer starts.

For instance, if an individual requests service on the refrigerator, and has a warranty contract, we are obliged to arrive for the service call on the next business day. So, if the request is submitted on Monday, between 8:00-5:00, we are required to visit the site by no later than Tuesday at 5:00. However, if a request is submitted on Thursday, after 5:00pm, we are required to visit the site no later than the following Monday at 5:00pm. Likewise, any request submitted after 5:00pm Friday and before 5:00pm Monday, is due for arrival by Tuesday at 5:00pm.

What may complicate matters further, the date/time stamps for both request and arrival are in two separate cells, Date in one (MM/DD/YY) and time in another (HH:MM); so I have 4 cells total for request and arrival:

Req Dt Req Tm Arr Dt Arr Tm
7/19/2011 12:48 PM 7/20/2011 10:00 AM

Any help with this is much appreciated. Holidays do count, but there are few enough that I can deal with those on an exception basis.

Thanks
AJ