Convert Text Time to Time

M

mdalby

I have text in the following format:

800
830
900
930

How can I convert these text to 8:00 AM, 8:30 AM etc...

Thanks,

M
 
E

ElsiePOA

One way
Use this formula:

=IF(A1/100<12,LEFT(A1,LEN(A1)-2)&":"&RIGHT(A1,2)&"AM",LEFT(A1,LEN(A1)-2)&":"&RIGHT(A1,2)&"PM")

There may be an easier way, perhaps using special formats, but thi
should do the job for you
 
Top