Microsoft KB Archive/68686

Multiplan: Formatting Hour Summary over 24 Hours PSS ID Number: Q68686 Article last modified on 01-30-1991 PSS database name: D_MPlan

1.x 2.x 3.x 4.00 4.01 4.20

MS-DOS

Summary:

When computing a sum of hours elapsed, the sum will never exceed 24 hours.

Example
In a spreadsheet, the following occurs:

END START RESULT 5:00:00 PM 7:57 AM 9:03 4:30:00 PM 8:01:44 AM 8:28 3:30:00 PM 8:02:21 AM 7:27 —– Total Number of Hours Elapsed: 29.98

The starting and ending times are formatted for hh:mm:ss AM/PM format, and the result is formatted for h:mm. The workaround to get the correct number of hours elapsed is to use the following formula in the RESULT column:

=SUM(first result cell:last result cell)*24.

This formula will give a value of 24.98 hours if formatted for fixed 00:00 for the above sample, rather than 0:58:55 if formatted for hh:mm:ss.

Reference(s):

Microsoft Product Support Technician. “Microsoft Multiplan User’s Guide” 4.20, Page 258

Copyright Microsoft Corporation 1991.