This problem seems to happen whenever changes are made to your browser, or sometimes for no apparent reason.
This problem seems to happen whenever changes are made to your browser, or sometimes for no apparent reason.
In Microsoft Excel, you can format a cell containing the sum of amounts of time that exceed 24 hours with the number format "[h]:mm:ss"; Microsoft Excel automatically adds times beyond 24 hours and formats them correctly.
<div class="section" id="kb_section">
<div class="sbody"></div>
<div class="sbody"><ol>
<li>To add times with a sum that exceeds 24 hours, use a normal sum formula: =SUM(Range)</li>
<li>Then, click <strong>Cells</strong> on the <strong>Format</strong> menu, click the <strong>Number</strong> tab, click <strong>Custom</strong> in the <strong>Category<span style="background-color: #ffff00;"> </span></strong><span style="background-color: #ffff00;">[h]:mm:ss<br /></span></li>
</ol></div>
<div class="sbody">This format works correctly with times that exceed 24 hours.</div>
<div class="sbody"></div>
<strong>Note:</strong> Range is either the defined name of a range that contains the times or the cell reference of the range that contains your times (for example, A1:A4). The values in the range must be in the "h:mm" or "hh:mm" format.
<div class="sbody"></div>
<div class="sbody">(from <a href="http://support.microsoft.com/kb/190633">http://support.microsoft.com/kb/190633</a>)</div>
</div>
Make cells containing days of the week, or any other data, stand out with this simple piece of VBA code.
I recently upgraded to Office 2007, I had hung on to 2003 as I didn't like the new ribbon menu. But the old version was starting to cause problems, so a copy of 2007 that I already had was installed.
Doing a simple thing like adding a line before an MS Word table or even a WordPress table is not simple sometimes!