Extract from varied texts

Originally Posted by rmexcell

Thank you so much...

If there is an entry of 7p-9:30p, the result is 7p-9:3 instead of 7p-9:30p. and 9:3 becomes 9:03 instead of 9:30

...

Those scenarios were Not included in your sample, my formula won't work for those.

If you need further help, please re-upload a sample with all possible string formats.

I really appreciate the help...
Here is updated example file, see lines 12-15.