How to convert time column to from HH:MM:SS to minutes and seconds?
40 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Arshey Dhangekar
le 1 Sep 2021
Commenté : Arshey Dhangekar
le 1 Sep 2021
I have a doubt , I want to convert Time column ( HH:MM:SS) to min, there is a direct command time2num but it requires toolbox and it's paid.So without using time2num how can I convert into minutes. I tried with datetime also but I got error.
table=readtable('sample.csv'):
times = datetime(table.Time,'InputFormat','HH:mm:ss:SSS');
times = hour(times).*60 + minute(times) + second(times)./60;
0 commentaires
Réponse acceptée
Chunru
le 1 Sep 2021
% table=readtable('sample.csv'):
A=readtable('sample.csv') % table is a function name in matlab
class(A.Time) % A.Time is duration and it is not the time
%times = datetime(A.Time,'InputFormat','HH:mm:ss:SSS')
% times = hour(times).*60 + minute(times) + second(times)./60;
% you are finding minutes from A.Time
t_minutes = minutes(A.Time)
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Tables dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!