need to find difference of two cells from one column in Excel
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
raghavendra kandukuri
le 22 Août 2018
Commenté : raghavendra kandukuri
le 22 Août 2018
Hi, I have an excel where column one(Time) has some values and column 5 (Duration), in duration i need to find the difference of 2nd element - 1st element from column one, i dont want to hard code that on excel, i want write that piece of code in .m file, how do i do it?
[num2, text, alldata2]=xlsread('exp2.xlsx');
temptime=num2(:,1); % getting column one from excel
holder=length(temptime); % getting to know how many elements are there in column one
i=1;
for i = 1:holder
duration()=(temptime(i)-temptime(i-1)); %its failing here
end
%% Excel is attached to this question
0 commentaires
Réponse acceptée
ahmed nebli
le 22 Août 2018
i think it should be done this way:
for i = 2:holder % the counter must get from 2 because temptime(i-1) would be error duration()=(temptime(i)-temptime(i-1)); %its failing here end
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Spreadsheets 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!