Date Time to elapsed Time
8 views (last 30 days)
Show older comments
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!
0 Comments
Accepted Answer
Cris LaPierre
on 6 Oct 2021
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';
More Answers (0)
See Also
Categories
Find more on Dates and Time in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!