Hi
I made minor corrections to your 'Tide Calendar' in particular the placement of the tides that have their records 11 lines below the date to which they refer. Dates are actual dates and not text.
To address the issue of the four values to build the chart I had in mind that the missing value refers to the following day tide value.
I put even auxiliary formulas that enable autofill your 'Tide calculation' table due to the 'Tide Calendar'.
Two additional notes:
1) Spaces in the sheet 'Tide Calendar' have code 160 instead of 32.
2) My system uses the comma as the decimal point, so the formula for converting
the text "2:32" in value can be simplified by removing the part of error correction
can be changed to
FORMULA]=--MID(J7,12,FIND("ft",J7)-12)[/FORMULA]
See the file
Bookmarks