Tips: Calculate hours between two dates in Excel

Here is a handy function to calculate the difference between two dates:

• =DATEDIF(Date1, Date2, Interval) where:
  
• interval="m" for number of months
• interval="d" for number of days
• interval="y" for number of years
• For example:
• =(DATEDIF(today(),A1, "d")-1) *24 is approximately number of hours between today and the date value stored in cell A1.

Reference:

• check out more details and examples in cpearson.com
  
• check out a ton of excel date/time tips in exceltips.com
  

Tips: Add Outlook Mail Box

Add additional mail boxes for Outlook 2003
1) go to Start; Setting; Control Panel
2) Double click on the Mail icon
3) Choose Email accounts
4) view or Change email accounts
5) Click on Microsoft Exchange Server and choose Change
6) Click on More Setting..
7) Goto the Advanced tab and click the Add ... button
8) Enter "Robert.Demo" and click OK
9) Continue clicking OK buttons to close up the Mail control panel

The 6 Worst Domain Names EVER! by the E-Commerce Diva Jamila White

These are pretty intelligent and legitimate sounding web sites, right?

• "Who Represents?", a database of agencies for the rich and famous
• Experts Exchange, a knowledge base where programmers can exchange advice and views
• Pen Island, a pen retailer
• Therapist Finder, a directory of counselors
• PowerGen Italia, a power utility company in Italy
• The Mole Station Native Nursery, an Australian plant nursery

Go to E-Commerce Diva Jamila White's site and check out what domain names they came up with!