I'm a yachtsman and need to mark tidal times on tidal atlases. For the
non-sailor, a tidal atlas shows on each page a geographical area with a
representation of tidal speed and direction for each hour up to 6 hrs before
or after high water at a standard port. Doing this manually is tedious. I
want to create an Excel 2000 spreadsheet that will automatically show hourly
up to 6 hrs before and 6 hrs after the time of high water for each day that I
type in. For example, if I type in a high water time of 23 Mar 08 2345
(perhaps in 2 adjacent colums), I would like automatically for the
spreadsheet to display to the left 23 Mar 08 2245, 23 Mar 2145 and so on up
to 6 hrs before high water. At the same time I would like it to display to
the right 24 Mar 08 0045 (note date change), 24 Mar 0145 etc up to 6 hrs
after high water time. I've tried to work this out but am stumped. Can
anyone suggest a way?