Try this
=(INT(A2)-INT(A1))*8.5+(MOD(A2,1)-MOD(A1,1))*24
--
HTH
Bob Phillips
"Mohammed Zenuwah" wrote in
message ...
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..
|