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.

--
Many Thanks. Warmest Regards,


"Mike" wrote:

=(A2-INT(A2))*24

Put in B2 should work.

Mike

"Polochilde" wrote:

Could you please tell how I could do the following

Cell A2 has 4:00 and I would like to see in B2 the number 4
In the same manner if A2 has 4:30 then B2 should show the number 4.5

I appreciate anyone's help.
--
Many Thanks. Warmest Regards,
Polochilde