showing hours elapsed not date and time data

1 visualizzazione (ultimi 30 giorni)
Abbey Kirkman
Abbey Kirkman il 26 Feb 2021
Commentato: Abbey Kirkman il 1 Mar 2021
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.

Risposte (2)

KSSV
KSSV il 26 Feb 2021
Let d be your datetime array.
d.Format = 'hh:mm:ss';
t = cellstr(d)
  1 Commento
Abbey Kirkman
Abbey Kirkman il 26 Feb 2021
hi thank you so much for your reponse unfortunetly i get the following error

Accedi per commentare.


Steven Lord
Steven Lord il 26 Feb 2021
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 Commento
Abbey Kirkman
Abbey Kirkman il 1 Mar 2021
hi i am using readmatrix to import my data. can readmatrix import data as a duration array?

Accedi per commentare.

Categorie

Scopri di più su Dates and Time in Help Center e File Exchange

Tag

Community Treasure Hunt

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

Start Hunting!

Translated by