Split concatenation
Try this:
=--RIGHT(A2,LEN(A2)-4)
and format the cell as a time in the format you require.
Hope this helps.
Pete
On May 18, 3:40*pm, 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
|