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.
 
Hi,

Format the cell as General or Number and you should be ok.

Cheers!
Jean-Guy
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Conditional Formatting 1
changing time to a number 1
Macro to paste x number of times 4
Negative time displaying as ##### 7
Sumproduct with date and time? 1
Help to create a macro 2
Average problem 1
Macro for copying a value to a variable no. of rows 6

Back
Top