time into a number

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
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
 
Back
Top