Results 1 to 4 of 4
  1. #1
    Join Date
    May 2002
    Posts
    157

    Unanswered: Calculating elapsed time

    I am working in MS Access 2003.
    I have three text boxes on a form:
    - TimeStart
    - TimeFinished
    - TotalTime

    TimeStart and TimeFinished are formatted to MEDIUM TIME and have an input mask of 99:00\ >LL;0;_ (i.e. 11:45 PM).

    Total Time is not formatted.

    Can anyone help with the calculation for time elasped? (ie if TimeStart is 10:00 AM and TimeFinished is 11:30 AM then the time elapsed should be 1:30 that is 1hour 30minutes)

    Please also advise how I should format the TotalTime text box.

    Thanks heaps in advance

  2. #2
    Join Date
    May 2010
    Posts
    601
    Quote Originally Posted by Karen Day View Post
    I am working in MS Access 2003.
    I have three text boxes on a form:
    - TimeStart
    - TimeFinished
    - TotalTime

    TimeStart and TimeFinished are formatted to MEDIUM TIME and have an input mask of 99:00\ >LL;0;_ (i.e. 11:45 PM).

    Total Time is not formatted.

    Can anyone help with the calculation for time elasped? (ie if TimeStart is 10:00 AM and TimeFinished is 11:30 AM then the time elapsed should be 1:30 that is 1hour 30minutes)

    Please also advise how I should format the TotalTime text box.

    Thanks heaps in advance
    See if this helps:

    How to Calculate Daily Hours Based on Clock In/Clock Out Times
    Boyd Trimmell aka HiTechCoach HiTechCoach.com (free access stuff)
    Microsoft MVP - Access Expert
    BPM/Accounting Systems/Inventory Control/CRM
    Programming: Nine different ways to do it right, a thousand ways to do it wrong.
    Binary--it's as easy as 1-10-11

  3. #3
    Join Date
    May 2002
    Posts
    157

    Thanks heaps works perfectly

    Thanks heaps works perfectly

  4. #4
    Join Date
    May 2010
    Posts
    601
    You're welcome.

    Glad I could assist.
    Boyd Trimmell aka HiTechCoach HiTechCoach.com (free access stuff)
    Microsoft MVP - Access Expert
    BPM/Accounting Systems/Inventory Control/CRM
    Programming: Nine different ways to do it right, a thousand ways to do it wrong.
    Binary--it's as easy as 1-10-11

Posting Permissions

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