Are these cells formatted as text or are they time values with a time format? If you attach your workbook, I can tell easily.
In the first case, you can extract the portion you want to another cell using a mid function:
=mid(a1,12,5)
The second case is much easier. All you need to do is reformat the data.
|