BLOG
Tag: MS Office

Articles

06-May-2015
Can't open links from Outlook or Word

This problem seems to happen whenever changes are made to your browser, or sometimes for no apparent reason.

Read More
19-Apr-2015
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>
</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>

Read More
19-May-2014
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
18-Feb-2014
Unblocking Attachments in Outlook 2007

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.

Read More
19-Mar-2011
Insert a blank line before a table

Doing a simple thing like adding a line before an MS Word table or even a WordPress table is not simple sometimes!

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