Formula returns 0 value shows #NAME? error in 2003, correct value in 2007

[JodyM]

I'm using Excel 2007 to create a worksheet for use in a 2003 environment. The spreadsheet works perfectly in Excel 2007, but gives me a #NAME? error in Excel 2003.

I have three columns with times and want to find the difference between the various times for task tracking.

Each of the three "input" columns are formatted as: 4/26/2010 8:18:00 AM
E = time request received (e.g., 4/26/2010 8:18:00 AM)
F = time request started (e.g., 4/26/2010 8:32:00 AM)
G = time request completed (e.g., 4/26/2010 11:54:00 AM)
H = # of documents completed for the task (number, e.g., 4)

I have three calculation columns that calculate the difference between the columns that return the number of days as a decimal. I'm using work days since the tasks can span a weekend. The working start time and working end time are contained in J2 and J3, respectively.

I = Pre-Work (D) Receipt to Start =IF(G7>0, ((NETWORKDAYS(E7,F7,)-1)*(J$3-J$2)+MOD(F7,1)-MOD(E7,1)), "")

J = Working Time (D) Start to Complete =IF(G7>0, ((NETWORKDAYS(F7,G7)-1)*(J$3-J$2)+MOD(G7,1)-MOD(F7,1))/(IF(H7>1,H7,1)), "")

(Note: the IF statement is to divide the working time by the number of documents to get an average time per document)

K = Turn Around Time (D) Receipt to Complete =IF(I7="", "", J7+I7)

The problem is when the value is 0 or close to 0, Excel 2003 returns a #NAME? error. This error does not appear in 2007.

How can I modify the formulas in I and J to display correctly in 2003?

[NBVC]

The NETWORKDAYS function is part of an addin in XL2003. In 2007, it is part of the normal functions.

In 2003, go to Tools|Addins and select Analysis Toolpak...

After installing, it should not show the error anymore.

[JodyM]

Wow, that was an easy fix. Thank you SO MUCH!!! I'll have my 2003 people try this and get back to you.

[JodyM]

All fixed! THANK YOU again!!!

[NBVC]

Thanks for getting back with your conclusion