How to convert my unique time format to excel time format

Dang, those are some useful hotkeys. Thanks for sharing! Unfortunately, it's not always real-time when I enter the time intervals- if it was, then this would be perfect. 

= LET( timeinput, A2:B14,
    adj_for_pm,    IF(RIGHT(timeinput,1)="p", 0.5, 0),
    n,     LEN(timeinput),
    h,     VALUE( IF(n<4, LEFT(timeinput, n-1), LEFT(timeinput, n-3)) ),
    m,     VALUE( IF(n<4, 0, MID(timeinput, n-2, 2)) ),
    adj_for_hr12, IF(h=12, -0.5, 0),
    TIME(h, m, 0) + adj_for_pm + adj_for_hr12
)

The 'adj_for_hr12' conditionally negates 'adj_for_pm', preventing miscalculation for times before 1:00 AM, and preventing overflow to the more than 1 day for times from noon until just before 1:00 PM.

Thanks to SnowMan55 identifying the problem, I was able to come up with the possible solution

=IF(
    ISNUMBER(timeInput),
    timeInput,
    LET(
        pm, IF(RIGHT(timeInput, 1) = "p", 0.5, 0),
        n, LEN(timeInput),
        h, IF(n < 4, LEFT(timeInput, n - 1), LEFT(timeInput, n - 3)),
        m, IF(n < 4, 0, MID(timeInput, n - 2, 2)),
        TIME(MOD(h, 12), m, 0) + pm
    )
)

in which h=0 is used in place of 12.

Which all goes to show the value of audit and testing?  Thank you.

Wow, thank you so much for doing this! I will try to reverse engineer it so I can apply the technique elsewhere. 

Hi, thanks for the response. Yes, 15 min intervals are all I need. That's a nice solution- one that I should have thought of! If you're curious, another user, (@peter Bartholomew), shared a solution using (what I consider to be) advanced functions and formulas. It's pretty cool, you should check it out. (scroll down)