Microsoft KB Archive/43236

Works: Calculating Elapsed Hours in Database PSS ID Number: Q43236 Article last modified on 04-12-1993 PSS database name: M_WorKs

1.10 2.00 3.00

MACINTOSH

Summary:

In a Works Database, to calculate the number of hours elapsed between two time fields:

  Create a new field.   From the Format menu, choose Set Field Attributes and select the Numeric and Computed options.   Enter the following formula =HOUR()-HOUR() where  and  are field names for the fields that contain the times. 

Additional reference words: 1.10 2.00 3.00

Copyright Microsoft Corporation 1993.