It might be worth trying
=(NETWORKDAYS(K2,O2)-1)*8+(MOD(O2,1)-MOD(K2,1))*24 if you want an answer in
decimal hours, or
=(NETWORKDAYS(K2,O2)-1)/3+MOD(O2,1)-MOD(K2,1) if you want an answer in
Excel time [h]:mm:ss

If you have start or end times which fall outside your defined working week
you'll have to define how to treat them, and modify the formula accordingly.
--
David Biddulph

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
For me that gives 72 hours, not the 8 hours that Raj requested.
It doesn't take account of the 8 hour working day, nor does it allow for
weekends.
--
David Biddulph

"Jacob Skaria" wrote in message
...
If O2 and K2 are in date/time formats..

=O2-K2

Use the above formula and format the cell to the below format. Right
clickFormat CellsCustom FormatType:=

[h]:mm:ss

If this post helps click Yes
---------------
Jacob Skaria


"Raj" wrote:

Hi All

I require a formula to compute the difference between 2 date stamps.
Here is
my requirement. We have time the issue is raised in K2 and target time
to
complete is in O2
for example
K2 : 5/29/2009 4:15:21 PM
O2: 6/1/2009 4:15:21 PM

The difference between this 2 must be 8 hours as we work from Monday to
friday
timings 9.00 to 17.00 daily.

Can anyone help me regarding this.

Raj