add time with hours and minutes?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • miraheem
    New Member
    • Feb 2013
    • 2

    add time with hours and minutes?

    hi,

    i have 3 text boxes

    the first one is names as: txt_tof
    the second one: txt_duration
    the third one: txt_ETA

    now i need to add the time entered in the text box "txt_tof" with the value entered in hours and minutes on the text box "txt_durati on" and display it in the text box "txt_ETA"

    how do you do this? please help? i need this urgently


    im gonna explain this in detail now

    the time of departure is entered in "txt_tof"

    and the duration of the flight is entered in "txt_durati on"

    i need to calculate this and the value should automatically display in the text box "txt_ETA" (estimated time of arrival)


    please help me.. give me the proper coding please.. VBA im using access 2007
  • Rabbit
    Recognized Expert MVP
    • Jan 2007
    • 12517

    #2
    You can use the DateAdd function to add date and time values.

    Comment

    • miraheem
      New Member
      • Feb 2013
      • 2

      #3
      can you please give me the coding? i am not good with codings

      thanks

      Comment

      • zmbd
        Recognized Expert Moderator Expert
        • Mar 2012
        • 5501

        #4
        Get help for built-in functions, properties, macro actions, and SQL keywords

        DateAdd Function

        Comment

        Working...