Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2002

    Question Unanswered: time card hours / calculating time


    I've been searching/playing all night on this with no luck. I'm looking to find the time difference between the following:

    TimeArrive - TimeCompleted = TotalTimeSpent (in short time)

    Do I do this in table: design view/default value or in a query, and if so how? If possible give details - I'm new but very eager to learn!


  2. #2
    Join Date
    Oct 2001
    Bay Area, CA
    You do that in a query.

    A simple SQL statement will look like this, the table where your TimeArrive and TimeCompleted is strored is called TimeTable:

    SELECT TimeTable.TimeArrive, TimeTable.TimeCompleted, Format([TimeArrive]-[TimeCompleted],"hh:nn") AS TotalTimeSpent
    FROM TimeTable;

Posting Permissions

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