CONVERT TIME FROM 4:30 TO 4.5

  • Thread starter Thread starter keeb
  • Start date Start date
K

keeb

I'm tring to convert a time ie. 4:30 to a interger ie. 4.5. can anyone help?
 
If A1 contains 4:30:00 (AM), then
=a1*24
(Format as general, not a time!)

And you'll see 4.5
 
Hi,

Multiply by 24 and format as general. So with your time in A1, in another
cell enter the formula

=A1*24

--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
 
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

Install framework 4.5 5
Split up summary sheet 2
Text to number value 1
Help with complicated calculation 2
Time sheet problem, help 5
help with Indirect formula 4
How to Convert MBOX to PST Online? 3
Windows 10 How do I stop Windows automatically adding a space after punctuation 3

Back
Top