Microsoft KB Archive/110314

Calculating Elapsed Time PSS ID Number: Q110314 Article last modified on 09-13-1994 PSS database name: HOMETOOL

3.00 MACINTOSH

= SUMMARY =

The following formula calculates a total elapsed time between a start time and an end time in the Microsoft Works Database or Spreadsheet module. This formula works if total elapsed time is less than 24 hours. Field Name Start = 1:00 pm Stop = 2:30 am Total Elapsed Time = 13.30 (This represents 13 hours and 30 minutes.) Enter the following formula in the Total Elapsed Time field and format this field as time: =If(stop<start,(stop-start)-hour(10),stop-start)

= MORE INFORMATION =

If you use this formula in the Spreadsheet, replace the field names for cell references.

KBCategory: KBSubcategory: Additional reference words: 3.00 mac calculated mwksdb mwksss time elapse fieldname

=
================================================================ Copyright Microsoft Corporation 1994.