In column A I have a long list of times but they all have the letters PM at the end. Is their a formula I could write in column B that would get rid of all the PM?
eg in column A:
7:45PM
10:30PM
I just want (in column B):
7:30
10:30
Thanks in advance