#NAME? Error occurs on one machine but not another!

[thehead]

Hi,

I have a created a spreadsheet which takes information from a SQL database and then checks the dates to how long it has taken my company to complete each call we take.

On my machine the spreadsheet works fine, (I have Excel XP) however whenever I move it to another machine (the other machines have Excel 2k) it throws up #NAME? errors whenever there is a call which failed to acheive its target time. The formula which gives the error is included below.

=IF(H5<>NULL, IF(INT(B5)=INT(H5),ROUND(24*(H5-B5),2),(24*(DayEnd-DayStart)*(MAX(NETWORKDAYS(B5+1,H5-1,HolidayList),0)+INT(24*(((H5-INT(H5))-(B5-INT(B5)))+(DayEnd-DayStart))/(24*(DayEnd-DayStart))))+MOD(ROUND(((24*(H5-INT(H5)))-24*DayStart)+(24*DayEnd-(24*(B5-INT(B5)))),2),ROUND((24*(DayEnd-DayStart)),2)))), NULL)

B5 = 12/03/2002 16:11:00
H5 = 13/03/2002 11:08:23
DayStart = 08:00
DayEnd = 18:00
HolidayList is an empty cell.

If you have any ideas then please let me know this is driving me crazy!

Tom. Webmaster of

http://www.netepic.org

The EPICentre and owner of Minatures Online. (10% off all VOID goods!)

 

[SkipVought]

Hi,
2 things

1. NETWORKDAYS is an Add-in from analysis toolpack. Is it installed on the OTHER machine.

2. NULL is NOT a valid spreadsheet value in 2K. Use &quot;&quot; instead.

Hope this helps.
Skip,
metzgsk@voughtaircraft.com