Find time elapsed in a table (for loop)?
1 view (last 30 days)
I have a table with two columns, TrialNumber and Minutes (attached).
The trials represented are
Using the Minutes column, how can I find how much time has elapsed for each of the trials?
I think to do this I would want to subtract the last row with the trial and take the Minutes and subtract from the first row with the trial.
Thank you in advance for your help!
Megumi Fukuda on 18 Apr 2021
Disclaimer: This anser is based on an assuption that the first row with a tt.TrialNumber contains the time ('tt.Minutes') where the trial actually started.
Your comment "I think to do this I would want to subtract the last row with the trial and take the Minutes and subtract from the first row with the trial." sounds sensible, and here is a snippet. duration_eachtrial should be what you want.
allTrials = unique(tt.TrialNumber); % extract all the trials in the mat file
for idx_trial = 1:length(allTrials)
duration_eachtrial(idx_trial) = tt.Minutes(tmp_trialidx(end))-tt.Minutes(tmp_trialidx(1));