MATLAB: Convert time column from hours to ddmmtheyyy HH:MM:SS

time

My time column is in hours (0000 01JAN1900=0hr) and starts from 999,312h (meaning 0000 01JAN2014). How would I convert a column vector of times (hrs) into a column of time in ddmmmyyyy HH:MM:SS format?

Best Answer

dth = 999312 + [0;1;12;24;36;42;31*24] % fake data
dth = 7×1
      999312
      999313
      999324
      999336
      999348
      999354
     1000056

●
dtm = datetime(dth*60*60, 'ConvertFrom','epochtime','Epoch','1900-01-01', 'Format','ddMMMyyyy HH:mm:ss')
dtm = 7×1 datetime array
   01Jan2014 00:00:00
   01Jan2014 01:00:00
   01Jan2014 12:00:00
   02Jan2014 00:00:00
   02Jan2014 12:00:00
   02Jan2014 18:00:00
   01Feb2014 00:00:00
Related Question