XL7:Auto Calculation For Summing Using 24-Hour Clock


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.


This behavior occurs when the first cell you have selected is formatted to
show the 24-hour-clock time format.


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:

  1. Select the group of cells you want to format
  2. On the Format menu, click Cells.
  3. Select the Time category on the Number tab.
  4. Click 26:30:55.


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.

ID članka: 135511 – Zadnji pregled: 14. feb. 2017 – Revizija: 1

Microsoft Excel 95 Standard Edition

Povratne informacije