Excel Dates and Times

Please feel free to use this content on your web site, but please include the links at the end.

Dates

=TODAY() returns the current date. This will update automatically whenever the sheet is refreshed or opened.
CTRL : returns the current date, but this will not update.

Times

=NOW() returns the date and time. This will update automatically whenever the sheet is refreshed or opened.
CTRL SHIFT : returns the current time, but this will not update.

Adding up Times

To add up a row or column of times, use the Sum function as if you were adding up numbers.
Then format the result

Excel 2003 users
Click Format | Cells | Number

Excel 2007/2010 users
Click Home [tab] Number [launcher]

In the Type box, put square brackets around the hh part of the format syntax as shown opposite.

Microsoft Office Training with Blue Pecan Computer Training. Tailored Microsoft Excel Training. Microsoft Excel Training Surrey

Formatting Text in HTML

For bold use or preferably 
For italic use or preferably 

To apply both:
Bold and Italic text
Make sure you close the tags in the opposite manner that you opened them.
To use these tags in a list nest them inside the <li> </li> tag

The CSS alternative for bold and italic:

For bold the font-weight rule can be used, the settings of which include bold, bolder and lighter. Normal is the default.
For italic the font-style rule can be used, the settings of which include italic or oblique. Normal is the default.

These rules can be used in the and <li> tags.

when multiple rules are applied they are separated by a semi-colon

Other HTML tags for formatting text
<tt> - changes the typeface to a monospaced font (letters and spaces are the same width). The default is Courier New, but can be changed in the Internet Options on a browser.

<pre> - causes exact spacing and line breaks to be preserved. The typeface is also monospaced.

<big> - causes big text

<small> - causes small text

<sup> - causes superscript text

<sub> - causes subscript text

CSS Rules for formatting text
font-family      sets the font (normally alternative fonts are given)
font-size          sets the font size
color                sets the font colour

separate alternative fonts with a comma, font names with space enclose in single quotes. Hexadecimals can be used for colours

If you have set the formatting for a paragraph or division, but then want to change the format for part of it – a word or sentence, use the tag. Specify the rule in the tag as you would within the tag.
 The text

NB as font name spellings can vary the only totally reliable fonts are:Times New Roman, Arial (PCs), Helvitica (Macs)

Please not all tags are HTML 5 compliant. HMTL 5 differences