Matlab imported excel time format change
1 view (last 30 days)
Show older comments
davit petraasya
on 8 Feb 2017
Commented: davit petraasya
on 12 Feb 2017
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!
0 Comments
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:
char(dt)
More Answers (0)
See Also
Categories
Find more on Shifting and Sorting Matrices in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!