Hi,

I need to work out waiting times from the date a request has been made to when the product was shipped out. The waiting time must only include working hours which is 8am to 6pm which equals 10 hours per day not 24 hours. It should also exclude weekends and public holidays. What is the best way to do this?

request date shipped out

01/05/2008 14:00 01/06/2008 15:00

Thanking you in advance.