Entry new date when date is a different day from previous entry

I have the array in the first picture (the one with only 2 rows) and would like to convert it to the array in the second picture (the one with 5 rows).

Many thanks in advance Victor

Answer 1

[Steven Lord]

I can't be certain, since your formatting isn't very clear, but are you trying to do something like this? You may want to transpose tableOfStartAndEndTimes, depending on how you want your data to be shown.

% sample data
x = datetime(2017, 9, 1) + hours(0:6:24);
tableOfStartAndEndTimes = [x(1:end-1); x(2:end)]

[Victor Lejona]

Hi Steven, I've updated the question with a couple of images, didn't realise about the wrong format.

Thanks, Victor

Answer 2

[Walter Roberson]

You can do calculations such as

for K = length(StartDate) : -1 : 1
  end_of_day = dateshift(StartDate(K), 'end', 'day');
  if end_of_day < EndDate(K)
    StartDate = [StartDate(1:K); end_of_day; StartDate(K+1:end)];
    EndDate = [EndDate(1:K-1); end_of_day; EndDate(K:end)];
  end
end

This works backwards breaking the entries as it goes. It does assume that the end date is at most the next day, not several days from now.

Working backwards doing insertions avoids a common off-by-one error that occurs if you work forward doing insertions.

Answer 3

[Peter Perkins]

You question is not described very clearly. It LOOKS like you want to split those start/end pairs into two pairs if they cross a midnight. Except that in one image you have 9/10/2016 11:10 and in the other you have 10/10/2016 11:10.

I think you need to clearly state what you want.