How do I calculate the duration between two times?
4 次查看(过去 30 天)
显示 更早的评论
Hi,
I have two different data sets that each contain times in the format 'HH:mm:ss'.
results_start_array (see attached) contains a list of general start times in the first column (each representing the general start time of a participant). Each time indicates when a participant started their task.
results_start_end (see attached) is a cell array of cells, with 12 tables in each cell. Each table has two times. Each of these tables represents a sub-task. In each table, the first row is a start time and the second row is a end time of each respective sub-task.
My goal is to calcualate all the different durations between (for each participant):
- start time of sub-task 1 - general start time
- end time of sub-task 1 - general start time
- start time of sub-task 2 - general start time
- end time of sub-task 2 - general start time
- start time of sub-task 3 - general start time
- end time of sub-task 3 - general start time
- etc. ...
I tried this out by calculating only the start time of sub-task 1 - general start time using this code:
% Extract the start time from results_start_array
start_time = results_start_array(1);
% Extract the end time from the first row in the first table in the first cell of results_start_end
end_time_str = results_start_end{1}{1, 'Time'};
% Convert the end time string to datetime object
end_time = datetime(end_time_str{1}, 'InputFormat', 'HH:mm:ss');
% Convert the start time to datetime object assuming it is in the same day
start_time_dt = datetime(start_time, 'ConvertFrom', 'duration', 'Format', 'HH:mm:ss');
% Calculate the duration between the two times
time_duration = end_time - start_time_dt;
% Display the duration
disp(time_duration);
Which didnt seem to work. What am I doing wrong and how can I fix this?
Thx
0 个评论
采纳的回答
Star Strider
2024-6-16
This seems to work —
load('results_start_array.mat')
whos('-file','results_start_array.mat')
load('results_start_end.mat')
whos('-file','results_start_end.mat')
r_start = results_start_array
r_start_end = results_start_end
r_start_end{1}{1}
r_start_end{end}{1}
for k1 = 1:numel(r_start)
% Q1 = numel(r_start_end{k1})
for k2 = 1:numel(r_start_end{k1})
% Q2 = r_start_end{k1}{k2}
ET{k1,k2} = r_start_end{k1}{k2}.Time - r_start(k1);
end
end
ET
r_start(1)
r_start_end{1}{1}
ET{1,1}
% ET{1,end}
% ET{end,1}
r_start(end)
r_start_end{end}{end}
ET{end,end}
I suggest that you check the results to be certain they make sense. However from my brief inspection of selected results, it doew what I believee you want.
.
更多回答(0 个)
另请参阅
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!