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)
  1 件のコメント
Abbey Kirkman
Abbey Kirkman 2021 年 2 月 26 日
hi thank you so much for your reponse unfortunetly i get the following error

サインインしてコメントする。


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 ExchangeSpreadsheets についてさらに検索

タグ

Community Treasure Hunt

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

Start Hunting!

Translated by