Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2002
    Location
    London
    Posts
    73

    Unanswered: Calculations between date and times

    Hi,

    In MS Access i'm trying to calculate the difference between one date time to another. for example

    26/04/2007 09:00 am
    07/03/2007 10:30 am (Current date time)

    This should work out the:

    days
    hours
    minutes
    seconds

    I did want this to be shown on a form

    Thanks

  2. #2
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    This will do the job!

    Difference = Format(EndTime.Value - StartTime.Value, "d:h:nn:ss")
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

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