Matlab imported excel time format change

Hi

Does anyone knows how to change change matlab time format. I have time in 2 colomns, first dd/mm/yyyy and second colomn hh:mm:ss.FFF. I need to make this time in one colomn in format yyyy-mm-dd hh:mm:ss.FFF.

Thanks in advance!

Answer 1

[Guillaume]

Assuming the date and time is stored as char arrays in both columns:

dt = datetime(strcat(column1, ' ', column2), ...
              'InputFormat', 'dd/MM/yyyy hh:mm:ss.SSS', ...
              'Format', 'yyyy-MM-dd hh:mm:ss.SSS')

If you want it back as char arrays:

char(dt)

[davit petraasya]

Thanks Guillaume for the answer.