Hi All,

I'm hoping someone can help me with the following problem.

I need to create a formula which calculates the different between two
date/time values excluding out of business hours.

Here's an example.
A1: 21/06/2005 10:00:00
A2: 23/06/2005 14:30:00

When using "=(B1-A1)*24" I can the result 52.5
If the business hours are between 08:30 and 17:00 the actual result required
is 21.5

I hope this makes sense.

Thanks in advance,

Mo..