changing time format

J

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.
 
F

Frank Kabel

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

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
 
Top