How do I create a formula to add hours to a mm/dd/yy h:mm format c

  • Thread starter Thread starter bm05
  • Start date Start date
B

bm05

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)
 
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
 
Sub test()
Dim dt1 As Date, dt2 As Date
dt1 = DateSerial(2008, 7, 1) + TimeSerial(1, 20, 0) 'y,m,d + h,m,s

dt2 = dt1 + TimeSerial(2, 0, 0)

MsgBox Format(dt1, "mmm/d/yy h:m") & vbCr & _
Format(dt2, "mmm/d/yy h:m")

End Sub
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I change dd/mm/yy to dd-month-yy? 6
Force users to enter a range of cell in dd/mm/yy hh:mm format 3
How do I set up a spread sheet that will add my hours work in h:mm 2
dd/mm/yy if i change to some other format 2
how to sort folders with name format "dd-mm-yy vacation x" inchronological order?? 3
How do I convert date input to mm/dd/yy 2
how do i change text format date to date (i.e., mm/yy to mm/dd/yyy 1
how do I add 3 hours to a time? 4

Back
Top