MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();

version()

8.0.30

create table incident_tab_22 (
  Incident_Time text
  );
insert into incident_tab_22 values
('10:37 A'),('03:15 A'),('12:20 P')

Records: 3  Duplicates: 0  Warnings: 0

select *, STR_TO_DATE(concat(Incident_Time,'M'), '%h:%i %p') as Time_of_Incident
  from incident_tab_22

Incident_Time
Time_of_Incident

10:37 A
10:37:00

03:15 A
03:15:00

12:20 P
12:20:00