Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Jun 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    527
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Elapsed time calc using dates (A2K / Win 2K)

    Hello everyone,
    In a query, I have a time/date stamp in one field. In another field I have a date, and another field contains a time. I have combined the separate date and time fields using (Format(dteDate + dteTime, "mm/dd/yy hh:mm"). Now what I need to do is take the first date and subtract the second date to give the number of hours elapsed. can anyone help with this calculation?

    Thanks,
    Mark

  2. #2
    Lounger
    Join Date
    Jan 2002
    Location
    Rochester, Kent, United Kingdom
    Posts
    32
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Elapsed time calc using dates (A2K / Win 2K)

    Hi Mark

    Try the DATEDIFF function.
    Help has some pretty good examples......

    Si

Posting Permissions

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