varfun applied to table not recognising equal values

I have 3 tables with two columns of time (intervals of 10minutes) and speed. The time column is in datetime format. I have stacked the three tables on top of each other and assigned valiables a and b to the new time and speed columns, respecivetly.

Then I used:

x=varfun(@mean,TT,'GroupingVariable','Date & Time')

However the function doesn't seem to recognise Dates & Times that are equal so in x, for example, there are say two 31May2010 15:10 rows.

Oddly, After this date/time the same thing happend for every xx:10 and xx:40 time.

How do I fix this?

Answer 1

[Steven Lord]

Are you sure the values are equal? They could be displayed as the same value without the stored value being the same.

dt1 = datetime('now')

dt1 = datetime
   10-Dec-2020 19:46:58

dt2 = dt1 + seconds(0.001)

dt2 = datetime
   10-Dec-2020 19:46:58

dt1 == dt2 % false

ans = logical
   0

dt2 - dt1

ans = duration
   00:00:00

seconds(dt2-dt1)

ans = 1.0000e-03

[Phoebe Armitage]

I have a rounding error, thank you!