I had to do what you see below. Not easy to do when you have 16,000 times you have to convert. So, I put a post on the Mr. Excel message board and one of the other outstanding members gave me the formula you see below. It's amazing!
Problem:
801a to 8:00 AM
1000p to 10:00 PM
Formula:
=IF(OR(RIGHT(A1)={"a","p"}),(TEXT(LEFT(A1,LEN(A1)-1),"00\:00 ")&RIGHT(A1)&"M")+0,"")
No comments:
Post a Comment