Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Jul 2002
    Location
    Petersburg, Virginia
    Posts
    54
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Calculating Time Difference (XP, sr2)

    I have a query that calculates the days between 2 dates by subtracting: DaysBetween=[SecondDate]-[FirstDate]. How do I calculate the MINUTES between 2 Time fields? The table field input mask is 99:00 >LL;0;_ (hours, minutes, am/pm).

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Calculating Time Difference (XP, sr2)

    You can use the DateDiff function.

    Minutes: DateDiff("n",[firsttime],[Secondtime])
    Regards
    John



Posting Permissions

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