|
[Use your browser's BACK button to return to the PRIME FAQ Page or click here if you came directly to this page.]
We wrote this FAQ to answer the many questions we receive on this topic from our clients and other inquiring minds in the many electronic communities we frequent.
Q: I downloaded your TimeIt utility from the Office Computing Web site. It works fine except when I add new times, I get the #NAME? error in the cell where the Elapsed Time Hours should be. The sample data correctly shows the rounded off number of hours. The formula in the cell for my new time is the same as the formulas in the cells above for the sample data. I tried to copy/paste the formula from the cell above to my new cell, but continue to get the #NAME? error.
A: (Quick introduction for readers not familiar with TimeIt ... TimeIt is a time tracker project we developed using Excel VBA for Office Computing's cover story in issue 4 (October 1997). TimeIt logs the hours spent on a client or a task, and then crunches the data so you can analyze and maximize your performance. Find out more about this and other article's we've done on our Resources page.
You don't have the Analysis ToolPak installed and loaded. The ToolPak provides the QUOTIENT() function because QUOTIENT() isn't supported in native Excel. In Office Computing issue 4, the project's Step 1 says, "This formula uses the QUOTIENT() worksheet function that is part of the Office 97 Analysis ToolPak, so make sure it's installed on your system. If it isn't available, run Office's Add/Remove wizard to install it. Then activate it from inside Excel by choosing Tools, Add-Ins, select Analysis ToolPak, and then click OK."
Double-check to make sure you have the ToolPak installed and loaded. Even if it's already installed it may not be loaded. To load it select Tools, Add-Ins, and check the "Analysis ToolPak" box, then click OK. The #NAME? error will no longer appear in your worksheet.
|
Return to Top