showing hours elapsed not date and time data

1 次查看（过去 30 天）
Abbey Kirkman
Abbey Kirkman 2021-2-26
评论： Abbey Kirkman 2021-3-1
hi so i am exporting data from excel :
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
[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.

请先登录，再回答此问题。

回答（2 个）

KSSV
KSSV 2021-2-26
Let d be your datetime array.
d.Format = 'hh:mm:ss';
t = cellstr(d)
Steven Lord
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.
  1 个评论
Abbey Kirkman
Abbey Kirkman 2021-3-1
hi i am using readmatrix to import my data. can readmatrix import data as a duration array?

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by