Tidal Calculation

[Chandrashekhar]

HI !I wanted to calculate the difference between to range of Tides as per following e.g. if on 1/2/07 @ 5.52 hrs tide hight is 1.80 meter and 1/2/07 @ 11.19 hrs tide hight reached to 3.73 meter then if i wanted to calculate that at what time the tide reach to 2 meter and how much time it takes to reach at 2 meter, if you can calcualte this it will be grate help for me
Tidal Variation for the month of February 2007 (Non-Monsoon Season)
Date Time( Hrs) Date Time Tide Height(m)
1-Feb 5:52 2/1/2007 5:52 1.80
1-Feb 11:19 2/1/2007 11:19 3.73
1-Feb 17:36 2/1/2007 17:36 0.91

can not attached excel file please advice

[Lotus123]

Okay...this answer makes several assumptions.

1) I'm going to assume your data is as follows:

Please Login or Register  to view this content.

2) I'm going to assume the tide raises and lowers at a steady rate...ie, it raises the same amount of inches from 6:00 to 6:15 as it does from 8:00 to 8:15, etc (which I know is not true - tides raise and lower more slowly as you approach the high and low).

3) I presume these times are are the exact moment of high and low tides (this goes along with item #2). Ie...at exactly 11:19 we reached high tide of 3.73....if high tide actually occured at 10:00 and 4.15 feet...there really is no way to even estimate (which is all we are going to be doing here).

Okay...the above are lots of assumptions...and the resulting answer is really just an average/estimate. It probably won't do you any good, but it at least answers the question based on the information provided

=(2-D3)/((D4-D3)/(B4+C4-B3-C3))+B3+C3
This formula will provide the time 2M was reached while approaching high tide...it occured at approximately 2/1/2007 6:25

=(2-D4)/((D5-D4)/(B5+C5-B4-C4))+B4+C4
This formula will provide the time 2M was reached while approaching low tide...it occurred at approximately 2/1/2007 15:10