Take UTC time data from excel, plot in MATlab
1 visualización (últimos 30 días)
Mostrar comentarios más antiguos
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:
0 comentarios
Respuestas (1)
Star Strider
el 5 de Nov. de 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.)
.
0 comentarios
Ver también
Categorías
Más información sobre Data Import from MATLAB en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!