Thank you to alll of you it works
--
Many Thanks. Warmest Regards,


"Gord Dibben" wrote:

Maybe your times are not real times?

Did you enter as 11:00 and 7:00

Where are they entered?

In A3 enter 11:30 In A4 enter 7:00

In A2 enter =A3-A4 which returns 4:30

In B2 enter the formula =(A2-INT(A2))*24 which returns 4.5


Gord Dibben MS Excel MVP

On Sun, 4 Mar 2007 12:36:17 -0800, Polochilde
wrote:

Dear Mike and Pinmaster,
Thank you so much for the reply.

Your formula keeps giving me 0:00

Too be clear if 4:00 (11:00am - 0700am)
and then your formula in the next cell still does not turn time difference
into a number.

I appreciate your help.