Getting rid of letters

[sobrien1234]

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

 

[Legacy 143009]

=TEXT(A1,"hh:mm")

Have a nice day

 

[Rick Rothstein]

=TEXT(A1,"hh:mm")

If the OP's posting is correct as shown, then your formula won't work as the OP does not have real time values in the cell (no space before the PM). If I am right, and the value is just text, then this should work...

=SUBSTITUTE(A1,"PM","")

 

[sobrien1234]

If the OP's posting is correct as shown, then your formula won't work as the OP does not have real time values in the cell (no space before the PM). If I am right, and the value is just text, then this should work...

=SUBSTITUTE(A1,"PM","")

Thanks - the substitute one worked perfectly!!