filter

awk -F'~' -v OFS='~' '{ 
    if ($3 ~ /[0-9]{3}AM$/ || $3 ~ /[0-9]{3}PM$/) {
        $3 = substr($3, 1, length($3)-6) substr($3, length($3)-1)
    }
    print
}' file.csv