MATLAB: Matlab imported excel time format change

changeformattime

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!

Best Answer

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)
Related Question