Extracting times from dataset titles

I have sets of data provided to me which have titles in a format which makes it very hard to manipulate for analysis. Essenttially i would like to extract this time from the title and paste it alongside the data in one of the colomns. As always it is easier to describe with an example. Please see attatched spreadsheet.

Many thanks

Alan