I have two files K_ship.xlsx (with data collected nearly every min) and K_ETR.xlsx (data collected maybe every 40 min). Both are attached.
I want to match the two files by data and time (in 2 columns, not combined) so that I can get 3 parameters from the larger file K_ship.xlsx that correspond to K_ETR.xlsx
I have written a script (also attached) used readtable and tried to subtract the two dates and the two times but I am a complete novice and I cant get the date format right.
I had posted a very messy post yesterday which I deleted and now I am only attaching my script and two data files and hopefully somone will help me!
Any other suggestions as to how to accomplish this are very welcome as i am here to learn!