Re: Time difference using seperate date and time fields

Tech-Archive recommends: Speed Up your PC by fixing your registry

Here's a link that contains several Date/Time calculation examples:
http://www.mvps.org/access/toc.htm#datetime

Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Office 2007 Preview Site:
http://www.microsoft.com/office/preview/default.mspx
Office 2007 Community Articles/Tutorials:
http://www.microsoft.com/office/preview/community/article_archive.mspx

TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/

"Walter" <Walter@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:23F57DB5-2265-47F0-BEF9-A321139EEF52@xxxxxxxxxxxxxxxx
I have a database that tracks downtime for ATM machines. I have four
seperate
fields:

Out Service Date
Out Service Time
In Service Date
In Service Time

These fields are manually entered into the db. I would like to
calcualte the
total downtime using both the date and time fields.

In plain English: Difference between "Out Service Date" "Out Service
Time"
and "In Service Date" "In Service Time"

Any help is greatly appreciated.
--
Walter


.

Relevant Pages