HOW FIND ERROR AND MERGE TWO TIME DATASET

Hello everyone, i have extract two data about time of entering and leaving home from a dataset, and i want merge the two data to know the duration of leaving home, but one of them has 1 more raw and i'm not able to merge them, someone know a way ?

Home=[Leave Enter];

Home.Duration=Home.Enter-Home.Leave;
duration1=find(Home.Duration < 0)

i use "duration1" to find if there is mistake in time association, so if the value of coloumn Duration is negative, somethings is wrong

thanks.

[dpb]

Add a NAT value to end of shorter and test 1:end-1 location...if it's beginning, then it'll be bum at first; if end just throw away the extra point.

If it's in between, one or the other should still lead to where there's an inconsistency. Of course, it's possible the whole thing is fouled up by some other mechanism than just being off a point, that's indeterminate from just the data alone although if all are positive that's probably pretty good check.

You could, of course, do crude checks that the start and end times are within the expected range of day(s)/hours to find if there's something really out of whack.

[dpb]

Alternatively, if you were sure of the first entries, you could catenate the two vertically and then sort.

[Emanuele De Astis]

but if i concatenate the two vertically, i have only one coloumn right?

[dpb]

Well, yes. But when they're sorted, they'll be in order and reshape() will restore two columns after get rid of odd man out...

[Emanuele De Astis]

understood, thanks