Microsoft KB Archive/59955

Multiplan: Creating Sum of Cells Formatted for Time PSS ID Number: Q59955 Article last modified on 07-12-1990 PSS database name: D_MPlan

3.00 3.01 3.02 3.04 4.00 4.01 4.20

MS-DOS

Summary:

Hours, minutes, and seconds may be entered using a time format for a cell provided that the time is less than 24 hours. A sum of cells containing this format shows the total time in days. Multiplication by a factor expresses the time in either hours, minutes, or seconds.

More Information:

The following procedure allows entry of a time that can be totaled or manipulated mathematically:

  Choose Format Cells and select a range of cells to be formatted.   Press the TAB key twice.   For Versions earlier than Multiplan Version 4.00, press the MINUS or HYPHEN key (-) and press ENTER. For Multiplan Versions 4.00 or later, press the RIGHT ARROW key, select “h:mm:ss”, and press the ENTER key.   Choose Alpha.   Enter the time. To enter 5 hours, 23 minutes, and 41 seconds, enter the following: 5:23:41 If the time is less than one hour, then a 0 (zero) must be entered for hours. To enter 12 minutes and 38 seconds, enter the following: 0:12:38 If the time is greater than 24 hours, the contents of the cell will be converted to a string and cannot be totaled or manipulated mathematically. A “#VALUE!” error message will be generated when you attempt to reference this cell as a number. To avoid this problem, make sure the time is less than 24 hours.   If more than one cell containing times are to be added together, the resulting number will be represented as time in days. Make sure that this sum is not formatted in date or time format.   To convert this number to hours, multiply by 24. To convert to minutes, multiply the sum by 24''60. To convert to seconds, multiply the sum by 24''60*60. The time format stores numbers accurately to within one second. 

Copyright Microsoft Corporation 1990.