Date Time to elapsed Time
显示 更早的评论
Hello there,
I am currently trying to convert the timestamp in a table to process time. I would like to set the first measuring point as t0 = 0 hours.
The table has 5151 entries. The time intervals between the measuring points are not constant.
This is how it looks at the moment:
Timestamp pO2
"09.21.2021 15:08:54" 101.525100000000
"09.21.2021 15:09:09" 101.416700000000
"09.21.2021 15:09:24" 101.188700000000
"09.21.2021 15:09:39" 101.080300000000
"..." "..."
This is how I would like it:
Time [h] pO2
0 101.525100000000
0,00416667 101.416700000000
0,00833333 101.188700000000
"...." "..."
Thanks in advance for the help!
采纳的回答
Cris LaPierre
2021-10-6
1 个投票
Read in the times as datetimes. Then subtract the first time from all times.
T.Timestamp = T.Timestamp-T.Timestamp(1);
% Set format to hour
T.Timestamp.Format = 'h';
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Dates and Time 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
