Hi Wigi
Thanks for your help. I tried your idea but in the columns either side of
the date/time I type in I get a decimal point and number whereas I need a new
decremented or incremented date/time. Any thoughts?
Thanks
Tremblers


"Wigi" wrote:

Hello

I you type in a time and add 1/24 to it, you are 1 hour after that time. Add
2/24 and you add 2 hours. Analogously, subtract 1/24 and you are 1 hour
earlier.

Is this clear?

--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Tremblers" wrote:

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?