Split concatenation
Hi,
You could do this and format the cell as time
=MID(A1,FIND(".",A1),LEN(A1))+0
or this
=TEXT(MID(A1,FIND(".",A1),LEN(A1)),"hh:mm")
--
Mike
When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
"Dale G" wrote:
Hi,
In cell A2, need to take this concatenated text and time string
510n0.240972222222222 and separate it in to cell B2 & C2. The left is the
text which I can get with =LEFT(A2,4) for my desired result of 510n. The
right I need to have in a time format like 5:47 that's where I'm stuck.
Any help is appreciated
|