I have excel data file that contains time inserted as text in inconsistent format.
I need a formula that format the any of these time into text in the form: 00:00 AM/PM
sample of the data that I see:
12am "two digits no space between number and am"
7 pm "1 digit with space between number and pm"
8:00pm "no space"
etc.
I need a formula that reads and exracts this type of data and clean it up as "00:00 AM/PM"
Thanks
I need a formula that format the any of these time into text in the form: 00:00 AM/PM
sample of the data that I see:
12am "two digits no space between number and am"
7 pm "1 digit with space between number and pm"
8:00pm "no space"
etc.
I need a formula that reads and exracts this type of data and clean it up as "00:00 AM/PM"
Thanks