Mac Works: How to Use Elapsed Time Formulas
  
PSS ID Number: Q136442
Article last modified on 10-22-1998
 
2.0 3.0 4.0 4.0a 4.0b
 
MACINTOSH
 

======================================================================
---------------------------------------------------------------------------
The information in this article applies to:
 
 - Microsoft Works for the Macintosh, versions 2.0, 3.0, 4.0, 4.0a, 4.0b
---------------------------------------------------------------------------
 
SUMMARY
=======
 
The following article shows you how to calculate total elapsed time between
a start time and an end time in a Works database or spreadsheet document.
 
MORE INFORMATION
================
 
In the Total Elapsed Time field or column, enter the following formula:
 
   =((EndDate+EndTime)-(StartDate+StartTime))*24
 
where EndDate is the end date, EndTime is the stop time, StartDate is the
start date, and StartTime is the start time.
 
For example:
 
   StartTime     EndTime    StartDate     EndDate
   5:00 PM       1:30 AM     1/15/96       1/16/96
 
   Total Elapsed Time = 8.5 (This is read as 8 hours, 30 minutes).
 
   NOTE: The "Total Elapsed Time" field should be formatted as "Number"
   with two decimal places.
 
Additional Example
------------------
 
 Column A = StartDate
 Column B = EndDate
 Column C = StartTime
 Column D = EndTime
 Column E = Total Elapsed Time
 
If you work from 5:00 PM on 1/15/96 to 1:00 AM on 1/16/96, use the
following formula to calculate the total time worked:
 
   In Cell E1, enter the following formula:
 
      =((B1+D1)-(A1+C1))*24
 
   In a Spreadsheet, to apply this formula to the cells below it, do the
   following:
 
NOTE: These steps are not necessary in a Works Database document. The
Database automatically fills-down the formula as new records are added.
 
1. Select cell E1 and extend the highlight to include the cells below.
 
2. On the Edit menu, click Fill Down.
 
Additional query words: kbhowto 2.00 3.00 2.00 3.00 4.00 mac m_works
mwksdb mwksss
======================================================================
Version           : 2.0 3.0 4.0 4.0a 4.0b
Platform          : MACINTOSH
Issue type        : kbhowto
=============================================================================
Copyright Microsoft Corporation 1998.