Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/100141

From BetaArchive Wiki

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.