XL7:Auto Calculation For Summing Using 24-Hour Clock
PSS ID Number: 135511
Article Last Modified on 10/22/2000
The information in this article applies to:
- Microsoft Excel for Windows 95 7.0
This article was previously published under Q135511
SYMPTOMS
In Microsoft Excel, when you use the AutoCalculate feature to view the sum
of a list of time values, you may see that the sum of the times is shown on
a 24-hour clock instead of being shown as a total sum of the times. For
example, when you sum three values of 9:00:00 AM, AutoCalculate may show
3:00:00 instead of 27:00:00.
CAUSE
This behavior occurs when the first cell you have selected is formatted to
show the 24-hour-clock time format.
WORKAROUND
To work around this problem, format the cells that contain the times with
the Time format greater that 24 hours. To format the cells to be greater
that 24 hours, use the following steps:
- Select the group of cells you want to format
- On the Format menu, click Cells.
- Select the Time category on the Number tab.
- Click 26:30:55.
MORE INFORMATION
The results of the AutoCalculate feature appear on the status bar;
AutoCalculate provides you with real-time information concerning the sum,
average, count, count nums, min, or max of the currently selected cells.
Keywords: KB135511
Technology: kbExcel95 kbExcel95Search kbExcelSearch kbExcelWinSearch