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