I entered this in J43 with the values provided by you in O45 (1/10/2008 14:00
) and M 46 (2/10/2008 12:00)

=((MIN($K$40,O45-ROUND(O45,0)+1)) - (MAX($K$39,M46-ROUND(M46,0)+1)) + 1)*24
and copied to J44 after copying O45 to O46 and M46 to M47 to get this
=((MIN($K$40,O46-ROUND(O46,0)+1)) - (MAX($K$39,M47-ROUND(M47,0)+1)) + 1)*24

I am getting 10 in both cases.

See what is different at your end. I tested both with Excell 2003 and 2007
on Windows XP.

Pl. note that 10 is decimal 10 and not 10:00 hours... since we have
multiplied the result with 24

I can send the sheet I have if you can send me an email.

To get my email id paste the following in an Excel cell and press Enter...
="to" & CHAR(95) & "sheeloo" & CHAR(64) & "hotmail.com"
--
Always provide your feedback...


"Dave08" wrote:

Seemsto be a problem. its returns a new value. 9 instead of 10