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.
