Probably your time is really a datetime formatted to show time part only.
Try to format cell with time in table as datetime, like "yyyy.mm.dd hh:nn:ss", and then look at data. When the date part is 01.01.1900, then the field is time only, otherwise it is datetime.
I prefer to format dates with Custom format - in your case it will be "hh:nn".
|