Help on Networkdays has your answer. You create a range of your holidays,
then tell the function where it is, as in:
=((Networkdays(c2,i2,x1:x10)...

Regards, Fred

"nigeo" wrote in message
...
I am using a formula
=((NETWORKDAYS(C2,I2)-1)*(Z$2-Y$2)+IF(NETWORKDAYS(I2,I2),MEDIAN(MOD(I2,1),Z$2,Y$ 2),Z$2)-MEDIAN(NETWORKDAYS(C2,C2)*MOD(C2,1),Z$2,Y$2))

this gives me working hours Mon-Fri (Y and Z = start and finish times)

now I need to incorporate bank holidays please can you advise what i need
to
do to the above formula
--
nigeo