Back

About MrExcel
Consulting Services
Learn Excel Resources
Challenge of the Month
MrExcel Seminars

Message Board

MrExcel Store
Podcast
Search
Contact
Home

 

 

Past Tip of the Day

 

Several quick answers today:

Jeff: I have figured out how to add Hour:Min, but now that I have that total - How do I multiply that times Dollars per hour?
If the total is in A10, and dollars per hour is in A11, then use =A10*24*A11

Richard: I have a macro to sort a worksheet. It works when the sheet is unprotected, but not when it is protected.
In your macro, unprotect the sheet, do the sort, then protect the sheet. Provided your sort routine does not crash, there is no danger that the user will be left with an unprotected sheet.

Chiles: Where can I download Excel
You can't. It comes on a couple of CD's. It is too big to download. You can download a competitive product called Star Office from http://www.sun.com/staroffice/

Robbie: I am having problems with relational data bases. could send me some tips to do them. Also a easy method saying what they are and how i carry then out on the computer.
Excel is not good at doing relational databases. Access is the product to use.


By Bill Jelen on 12-Dec-2001

MrExcel.com Consulting can be hired to implement this concept, or many other cool applications, with your data.

MrExcel.com provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Visual Basic procedures on this web site are provided "as is" and we do not guarantee that they can be used in all situations.

 

Excel is a registered trademark of the Microsoft® Corporation.

All contents Copyright 1998-2008 by MrExcel Consulting.