Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Posts
    24

    Unanswered: Some time Calculation help Please

    Hi guys and gals,

    I have been looking all over the internet with every search engine I can think of, but I cannot find an answer to this one.
    I know it must be easy..,

    but what I want to do is take an existing time field in ms access, and then have another calclated field that takes the existing time field and adds a number of hours to it, such as 5 hours.., what I am doing is working my way to Universal Time.
    any ideas ?

    thanks,
    Kevin Rea
    krea@msaccessapps.com

  2. #2
    Join Date
    Oct 2003
    Location
    Canada
    Posts
    574
    I would use DateAdd("h", intTimeZone, TheTime)

    TheTime is the time field and intTimeZone would be your 5 hours.

  3. #3
    Join Date
    Oct 2003
    Posts
    24

    yes

    that worked very nicely... thank you very much.

    kevin

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •