tide

Hi All I think this is a question to test the chaps who specialise in difficult formula I am working on something that requires me to adjust tide times from UTC to a format that accommodates the seasonal changes in the UK for British Summer Time. Below is an explanation from the UK Government...

Hi there. Another silly question for the day. <tbody> A B C D 1 Date Low Tide High Tide Moon 2 1/2/18 06:30 13:00 Full 3 2/2/18 07:15 13:45 1 Day Past Full 4 2/2/18 </tbody> Take for instance the above table, As an example i have entered into A3 and A4 the same dates, Obviously...

Good afternoon fellow peeps. I am struggling bit time with this one, and no amount of research online is assisting me with the correct formula I have as follows <tbody> A B C D E F 1 High Tide Minus 15 minutes High Tide High Tide Plus 15 Minutes Recorded time 2 =B2-15/1440 13:25...

I am working with tides and want to know the tide height at a certain time of day. I know the time of the high tide and low tides; in this case, there are two of each. I have searched and searched for a model to figure this out. So for example: Time tide 5:16 2.1 ft 11:25...