Hi,
I have a tide table of the daily water flow in a river during various periods of the day, maybe 3, 4 or 5 observations a day for a particular month. I want to automatically find the high tide for the day and find the total number of days in a month that have tides above 5 meters and between 4 and 5 meters etc. I have attached the link for the excel sheet below for your reference.
http://rapidshare.com/files/449422038/tides.xls
I would appreciate your help.
Thanks
I have a tide table of the daily water flow in a river during various periods of the day, maybe 3, 4 or 5 observations a day for a particular month. I want to automatically find the high tide for the day and find the total number of days in a month that have tides above 5 meters and between 4 and 5 meters etc. I have attached the link for the excel sheet below for your reference.
http://rapidshare.com/files/449422038/tides.xls
I would appreciate your help.
Thanks