Thread: How do I create a formula to add hours to a mm/dd/yy h:mm format c
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Franz Erhart Franz Erhart is offline
external usenet poster
  
Posts: 18
Default How do I create a formula to add hours to a mm/dd/yy h:mm format c
Just add 0.0416666666 to the value of Ft. Mchenry

formated as number:
39672,0000000000
39672,0416666666

formated as date/time
12.08.2008 00:00
12.08.2008 01:00



"bm05" wrote:

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)
Reply With QuoteReply With Quote