showing hours elapsed not date and time data
1 次查看(过去 30 天)
显示 更早的评论
hi so i am exporting data from excel :
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/532319/image.png)
however when i get the data into matlab it is given as serial numbers and when i use datestr to change it into time it doesnt give me the hours elapsed rather ![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/532324/image.png)
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/532324/image.png)
[sorry for poor quality]
how can i get my data in matlab to look exactly like it was in excel so i can plot it against other values.
0 个评论
回答(2 个)
Steven Lord
2021-2-26
How are you importing this data from Microsoft Excel? See if the function or technique you're using to import the data can import it as a duration array not text or datetime.
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!