how to covert matlab time to actual time

3 visualizaciones (últimos 30 días)
swetha S
swetha S el 18 de Oct. de 2019
Respondida: Andrei Bobrov el 18 de Oct. de 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 comentarios
Andrei Bobrov
Andrei Bobrov el 18 de Oct. de 2019
Here ttach your xlsx-file.
swetha S
swetha S el 18 de Oct. de 2019
.xlsx file

Iniciar sesión para comentar.

Respuesta aceptada

Andrei Bobrov
Andrei Bobrov el 18 de Oct. de 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]));

Más respuestas (0)

Etiquetas

Community Treasure Hunt

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

Start Hunting!

Translated by