=(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