INF: How to Use TimeValue() to Calculate Difference in Times
  
PSS ID Number: Q100141
Article last modified on 03-13-1995
 
1.00 1.10 2.00
 
WINDOWS
 

---------------------------------------------------------------------
The information in this article applies to:
 
 - Microsoft Access versions 1.0, 1.1, and 2.0
---------------------------------------------------------------------
 
SUMMARY
=======
 
This article describes how to use the TimeValue() function to find the
difference between two values that have Date/Time data types and that
occur within a 24-hour period.
 
MORE INFORMATION
================
 
To set up an example that uses the TimeValue() function, create a form
with the following text boxes:
 
   Object: Text Box
   ----------------
   ControlName: Start_Time
 
   Object: Text Box
   ----------------
   ControlName: End_Time
 
To calculate the difference between the times in these two fields,
create a third text box with the following properties:
 
NOTE: In the following sample code, an underscore (_) is used as a
line-continuation character. Remove the underscore when re-creating
this code.
 
   Object: Text Box
   ----------------
   ControlName: Time_Difference
   ControlSource: =Format(TimeValue([End_Time])_
                   -TimeValue([Start_Time]),"Short Time")
 
Note that in the example above, the Format() function is used to
format the time difference. Short Time displays the difference in
hours and minutes.
 
REFERENCES
==========
 
For more information on formatting values, search for "format" then
"format, format$" using the Microsoft Access Help menu.
 
Additional reference words: 1.00 1.10 2.00
KBCategory: kbprg
KBSubcategory: PgmOthr
 
=============================================================================
 
Copyright Microsoft Corporation 1995.
