Are you sure they are true time values ?

What does =ISNUMBER(A1) return where A1 is meant to represent a cell containing the time ?

If it's FALSE you need to coerce your times store as text to time (decimal numbers) - to do en masse - highlight column and run Data -> Text to Columns -> Finish and then alter format of cells accordingly