How to subtract one cell with previous cell in the table in matlab and do it consecutively until the last row?

4 Ansichten (letzte 30 Tage)
Hi! I need your help. Actually I can do this in excel, but I am curious about how to do it in Matlab. I attach the picture in excel about the mathematical operation I want to do. I want to calculate the duration in minutes by substracting one cell with previous cell and multiply it by 24*60. I also want to do it consecutively until the last row. Do you know how to do it with matlab code? Suppose I have a table with three variables, the first one for duration, the second one for rainfall intensity (mm/min) and the third one for the duration (minutes) which I want to calculate. Could you please help me? Thank you very much in advance.

Akzeptierte Antwort

Image Analyst
Image Analyst am 4 Nov. 2017
diff() will give you the difference between rows of each column in your table, t. For example:
dDate = diff(t.Dates);
dt = diff(t.Rainfall);
dd = diff(t.duration);

Weitere Antworten (0)

Community Treasure Hunt

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

Start Hunting!

Translated by