Error with NETWORK DAYS function

D

Darran

Im trying to use an old spreadsheet that I have not used for a few months.
But when I go back to try and update the data, I am getting the #NAME? error
in the result cell. I have just tried to update an existing time by just 1
hour and it loses the result. The sum that is running is:

=((NETWORKDAYS(D10,F10,K9:L10)-1)*10)+((G10 -E10)*24)

we work a 10 day, monday - friday and are looking to calculate the
difference in hours between 2 dates and times. If anyone can assist here I
will be most grateful.
 
D

Darran

Not to worry people, I have sovled it myself. I had upgraded Excel since I
last used the spreadsheet so I needed to install the add-in pack again to get
it working.
 
B

Bondi

Hi Darran,

You need to install the Analysis Tool Pack.
Goto Tools -> Add Ins and here make sure the Analysis Tool Pack is
marked,

Regards,
Bondi
 
Top