Matlab imported excel time format change

2 views (last 30 days)
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!

Accepted Answer

Guillaume on 8 Feb 2017
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:

More Answers (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!