how to covert matlab time to actual time

1 vue (au cours des 30 derniers jours)
swetha S
swetha S le 18 Oct 2019
Réponse apportée : Andrei Bobrov le 18 Oct 2019
I used [num txt raw]= xlsread(sprintf( 'SMPS%d.xlsx',n),'Data'); to read the excel files. The raw variable is of dimension (480*109). The first three columns are "sample no, date , time". The original format for time is HH:MM:SS but in Matlab the time column has values 0.0035,0.0056,0.0077 etc. I want to convert this whole column to actual time values as i have to further process this using time.
  2 commentaires
Andrei Bobrov
Andrei Bobrov le 18 Oct 2019
Here ttach your xlsx-file.
swetha S
swetha S le 18 Oct 2019
.xlsx file

Connectez-vous pour commenter.

Connectez-vous pour répondre à cette question.

Réponse acceptée

Andrei Bobrov
Andrei Bobrov le 18 Oct 2019
T = readtable('SMPS1.xlsx','Sheet','Data','Range','1:481');
T.Time = dateshift(datetime(T.Date,'InputFormat','MM/dd/uuuu') + seconds(T.StartTime*24*60*60),'start','second','nearest');
TT = table2timetable(T(:,[4:end]));

Plus de réponses (0)

Catégories

En savoir plus sur Dates and Time dans Help Center et File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by