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

3.00
MACINTOSH

-------------------------------------------------------------------
The information in this article applies to:

 - Microsoft Works for the Macintosh, version 3.0
-------------------------------------------------------------------

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.