Copying Time from Notepad to Excel

So i have a list of start and end time that i have a formula referencing. some of the times isnt being recognized by my formula so i copied it in notepad and then back to excel to get un formatted data however from excel it is pasting an extra AM or PM and overwriting data in my other columns. i have attached a copy