Time between two dates

52 views (last 30 days)
Miguel Herrera
Miguel Herrera on 18 Apr 2018
Answered: Steven Brossi on 8 Aug 2022
Lets say I have a time T1 = '2018-03-14 16:30:54' and another T2 = '2018-03-14 16:40:54' How can I find the total duration of the interval, as well as a "midpoint" in between said interval? My goal is to add an NaN entry every time there is a time gap greater than 10 minutes.
For example; '2018-03-14 16:30:54' '2018-03-14 16:40:54' %NaN entry would be added here '2018-03-14 17:20:15' '2018-03-14 17:30:15'
The purpose of adding this entry would be to remove discontinuity in graphs.

Accepted Answer

the cyclist
the cyclist on 18 Apr 2018
Edited: the cyclist on 18 Apr 2018
T1 = datetime('2018-03-14 16:30:54');
T2 = datetime('2018-03-14 16:40:54');
dT = T2 - T1;
T_mid = T1 + dT/2;
  3 Comments
the cyclist
the cyclist on 19 Apr 2018
Edited: the cyclist on 19 Apr 2018
There might be a better way, but ...
dT > duration('12:00','InputFormat','mm:ss')
Peter Perkins
Peter Perkins on 19 Apr 2018
dT > hours(12)
The cyclists code will work in R2018a or later, but in any case using hours seems much more readable to me.

Sign in to comment.

More Answers (2)

Peter Perkins
Peter Perkins on 19 Apr 2018
>> d = datetime(2018,3,14,16,[30 40],54)
d = 
  1×2 datetime array
   14-Mar-2018 16:30:54   14-Mar-2018 16:40:54
>> mean(d)
ans = 
  datetime
   14-Mar-2018 16:35:54
>> diff(d)
ans = 
  duration
   00:10:00

Steven Brossi
Steven Brossi on 8 Aug 2022
How about
T1 = datetime('2018-03-14 16:30:54')
T1 = datetime
14-Mar-2018 16:30:54
T2 = datetime('2018-03-14 16:40:54')
T2 = datetime
14-Mar-2018 16:40:54
T_mid = mean([T1, T2])
T_mid = datetime
14-Mar-2018 16:35:54

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!