Separate two hours from one cell to two

S

something68

I HAVE ANOTHER DOOZY!

In Column A, row 8 I show: A, S
In Column A, row 9 I show: 1.0, 7.0

I would like Column M, row 9 to show: 1 (just the “A†amount)
I would like Column O, row 9 to show: 7 (just the “S†amount)
 
K

KC

use formula

in Column M9
=LEFT(A9,FIND(",",A9,1)-1)
if you want to error handle then use
=IF(ISERROR(LEFT(A9,FIND(",",A9,1)-1)),"",LEFT(A9,FIND(",",A9,1)-1))

in Column O9
=RIGHT(A9,FIND(",",A9,1)-1)
if you want to error handle then use
=IF(ISERROR(RIGHT(A9,FIND(",",A9,1)-1)),"",RIGHT(A9,FIND(",",A9,1)-1))

-kc
*Click YES if this helps
 
M

Mike H

Hi,

Try these

The "A" amount
=LEFT(A9,FIND(",",A9)-1)

The "S" amount and I have assumed the space after the comma is always there.
=MID(A9,FIND(" ",A9)+1,LEN(A9))

Mike
 

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

Top