Calculating Time in new field

[Ray W]

I have two Date/Time (general date and time) fields that I need to calculate
the difference between the two. I'm only interested in the hh:mm:ss that have
elapsed between the two.
I've already added the field to the table (MTTR) but I will need to perform
an update query that adds this calculation into the new field. And I would
like to have the calculation performed as I a .csv file.

Thanks,

 

[Georgia Bryant]

I have two Date/Time (general date and time) fields that I need to
calculate
the difference between the two. I'm only interested in the hh:mm:ss that
have
elapsed between the two.
I've already added the field to the table (MTTR) but I will need to
perform
an update query that adds this calculation into the new field. And I would
like to have the calculation performed as I a .csv file.

Thanks,

 

[Douglas J. Steele]

Don't add the field to the table. Instead, create a query that includes the
calculation, and export the query, not the table.

For one way to get the difference in hh:nn:ss format, see
http://www.accessmvp.com/DJSteele/Diff2Dates.html

 

[Rastro]

As Doug said export the result of the query:

SELECT RecordID, Format([Check_Out]-[CheckIn],"hh:nn:ss") AS DifTime
FROM YourTable;

Rastro

 

[John W. Vinson]

As Doug said export the result of the query:

SELECT RecordID, Format([Check_Out]-[CheckIn],"hh:nn:ss") AS DifTime
FROM YourTable;

Rastro

I have two Date/Time (general date and time) fields that I need to
calculate
the difference between the two. I'm only interested in the hh:mm:ss that
have
elapsed between the two.
I've already added the field to the table (MTTR) but I will need to
perform
an update query that adds this calculation into the new field. And I would
like to have the calculation performed as I a .csv file.

Thanks,

Just note that this will fail for times exceeding 24 hours. Subtracting two
date/time values gives a Date/Time value, a double float count of days and
fractions of a day since midnight, December 30, 1899; so a duration of 26
hours will correspond to #12/31/1899 02:00:00# and will display as "02:00:00".