showing hours elapsed not date and time data
Mostra commenti meno recenti
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
il 26 Feb 2021
Let d be your datetime array.
d.Format = 'hh:mm:ss';
t = cellstr(d)
1 Commento
Abbey Kirkman
il 26 Feb 2021
Steven Lord
il 26 Feb 2021
0 voti
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
il 1 Mar 2021
Categorie
Scopri di più su Spreadsheets in Centro assistenza e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
