How to import Date&Time data

Greetings.

I'm trying to import via Import Data wizard such kind of data:

20130826;10:01:00;133.7700000;133.9600000;133.6200000;133.7300000;161810
20130826;10:02:00;133.7300000;133.8500000;133.6500000;133.6500000;75480
20130826;10:03:00;133.6700000;133.7600000;133.6500000;133.7500000;33790
20130826;10:04:00;133.7000000;133.7500000;133.6500000;133.6600000;14330

To import Time column i use Custom date format HH:MM:SS

but cell 10:01:00 after import looks like 35235.416666667
Date column 20130826 via custom format yyyymmdd i get as 735472

Please advise, how to import such data correctly? Thanks

Answer 1

[Azzi Abdelmalek]

a=735472; 
% to retrieve you date
datestr(a,'yyyy-mm-dd')

b=35235.416666667;
datestr(b,'HH:MM:SS')