The information in this article applies to:
SYMPTOMSIn 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. CAUSEThis behavior occurs when the first cell you have selected is formatted to show the 24-hour-clock time format. WORKAROUNDTo 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:
MORE INFORMATIONThe 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 : xlwin |
Last Reviewed: October 20, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |