Microsoft KB Archive/136442

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.