View Single Post
 
Old 03-27-2017, 09:20 AM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

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.