Tag: Excel


Working with time periods that exceed 24 hours in Excel

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>
<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=""></a>)</div>

Read More
Colouring Excel Cells by Day of Week

Make cells containing days of the week, or any other data, stand out with this simple piece of VBA code.

Read More
linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram