How do I select particular data from excel file
3 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Debayan Mandal
am 4 Dez. 2018
Kommentiert: Debayan Mandal
am 4 Dez. 2018
I have an excel file with 2 colum title namely date and time , value. I want each date 14:30 value only. Is it possible to do so?
thanks in advance
0 Kommentare
Akzeptierte Antwort
Kevin Chng
am 4 Dez. 2018
Bearbeitet: Kevin Chng
am 4 Dez. 2018
Yes. Try
a = readtable('test.xlsx');
b = a((hour(a.Date_Time)==14 & minute(a.Date_Time)==30),:)
Use logic to get the index of a when hour is 14 and minutes is 30.
Accept my answer if it is working for you.
2 Kommentare
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!