Take UTC time data from excel, plot in MATlab

7 views (last 30 days)
I have time data in UTC in an excel file that I want to plot along the x-axis. MATlab seems to have taken the data and converted it into decimal numbers, but I want to display it as it's formatted in Excel. I've tried using the datetime command, but I'm not very familier with it. Below is thow I want it formatted, the code I have, and the current plot output.
This is how I want it formatted
This is the code I have:
time = angleData(1:end,1);
timeUTC= datetime(time, "TimeZone","UTC");
plot(timeUTC, boreAngle)
Current output with my code:

Answers (1)

Star Strider
Star Strider on 5 Nov 2022
I have no idea what the problem is, however if time in‘HH:mm:ss’ format in Excel is being imported as decimal numbers in MATLAB, one option could be:
timeUTC = datetime(angleData(:,1), 'ConvertFrom','excel', 'TimeZone','UTC')
See if that does what you want. (I can’t test it because I don’t have the data.)
.

Community Treasure Hunt

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

Start Hunting!