Problem: Time Computations

[rweeden]

How can I set up a field to give me the time difference of two time fields?
I am trying to determine the difference in hours and minutes between an
entry time and an exit time, then between the exit time and a re-entry time.

Bob W

 

[Mike]

Bob, In a query, with the subject table in it, start a
new column that says,
entry time:[exit time]-[entry time]
and another column that says,
re-entry time:[entry time]-[exit time]
Enter all that data in the top line. Substitute your field
names between the brackets. MAKE SURE THAT YOU USE THE
COLON AND THE BRACKETS AS I HAVE OR IT WON'T WORK! Good
Luck. Mike