View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
bm05 bm05 is offline
external usenet poster
 
Posts: 1
Default How do I create a formula to add hours to a mm/dd/yy h:mm format c

I wish to create a tide predictor. I have the stated date/time for High and
Low tide. I wiould like to create a formula to add/subtract hours based on
different locations in the region.

Ft. Mchenry - High Tide 7/01/2008 01:20
new location Sandy Pt. is Ft Mchenry High Tide plus 2 hours (should equal
7/01/2008 03:20)