Convert Time in Text format to time

Hello there,

Thank you for getting to my question.

I have time in the following text format and want to convert to time and derive the AM PM based on the last alphabet.

For example:

0819A - 08:19 AM
1258P - 12:58 PM
0301P - 03:01 PM
1006A - 10:06 AM
0502P - 05:02 PM

Can someone please help?

Oh I am sorry, I dint explain properly. I meant my column has values as below(Column A) and I want the value under the result column.

Column A RESULT

0819A 08:19 AM
1258P 12:58 PM
0301P 03:01 PM
1006A 10:06 AM
0502P 05:02 PM

It's still no clearer, but I think you have 0819A in A1, so try this in B1:

=LEFT(A1,2)/24 + MID(A1,3,2)/24/60 + (RIGHT(A1)="P")*0.5

Format the cell as "hh:mm am/pm"

Hope this helps.

Pete