changing time format

[JT]

I have a spreadsheet where the time is displayed as 0405P
or 1115A.

What code can I use to change the time to 04:05:00 PM or
11:15:00 AM?

Thanks for the help.

 

[Frank Kabel]

Hi
in a separate cell enter the formula
=TIMEVALUE(LEFT(A1,2)&":"&MID(A1,3,2) & " " & RIGHT(A1,1) & "M")

 

[Trevor Shuttleworth]

For that display, you must have a custom format of "hhmmA/P"

Just go to Format | Cells... | Number | Category: Custom | Type: "hh:mm:ss
AM/PM"

Regards

Trevor