Convert Timeformat into Text format

[rizmomin]

Hello:

Please refer to attached file.
I have Time format data in column A.
I like to convert these data into TEXT format.

Let me know if you have any questions.
Thanks.

RM

[berlan]

Using a formula, you could try,

A2: =TEXT(A1,"h:mm:ss AM/PM")

and copy down

[Tony Valko]

Not real clear what you mean.

Maybe show us what results you expect.

Also, all the data in the sample file is exactly the same. Show us some different examples.

[berlan]

From what I understand, you want to convert the date value to text strings, like when using the following vba procedure?

Please Login or Register  to view this content.

[rizmomin]

Hi Berlan:

Thanks a lot..
Works
RM

[berlan]

You're welcome