Hi,

Your other response made me aware that I'd missed publich holidays so change

to this

=(NETWORKDAYS(A1,A2,C1:C8)-1)*(B2-B1)+IF(NETWORKDAYS(A2,A2),MEDIAN(MOD(A2,1),B2,B1),B2)-MEDIAN(NETWORKDAYS(A1,A1)*MOD(A1,1),B2,B1)

Where C1 to C8 is your holiday list. Just a point to note is that I have

assumed that a public holiday wouldn't be either of the dates in A1 or A2. If

these dates were public holidays then the real start/end date is a day

later/earlier and in any case I'm struggling to work it out otherwise.

Perhaps someone can enlighten us.

Mike

CHRISTI said:

I need to calculate the total WORK-hours (08:00-17:00) between two

date/time-stamps;

-excluding WEEKENDS

-excluding PUBLIC HOLIDAYS

eg#1.: A1=START DATE/TIME & A2=END DATE/TIME & A3=RESULT ([hh]:mm)

A1 11-01-2008 09:00:00

A2 11-01-2008 11:00:00

A3 02:00

eg#2.: A1=START DATE/TIME & A2=END DATE/TIME & A3=RESULT ([hh]:mm)

A1 11-01-2008 09:00:00

A2 14-01-2008 11:00:00

A3 11:00

eg#3.: A1=START DATE/TIME & A2=END DATE/TIME & A3=RESULT ([hh]:mm)

A1 14-01-2008 09:00:00

A2 16-01-2008 11:00:00

A3 20:00