Hi,
I would greatly appreciate if someone could help with the following: I am
trying to get a negative result for a missed deadline.

I have determined the formula when the deadline is met:
deadline (A1) report released (B1) result
01/11/05 6:00 pm 01/11/05 5:45 pm 0:15:00

I used the following formula to generate the above result:
=Mod(A1,1)-MOD(B1,1)+(NETWORKDAYS(B1,A1,Holidays)-1)*3/8

What forumula should be used if the report is released after the deadline;
based on the following parameters: monday-friday 9am-6pm workday; where
holidays are excluded and the deadline time is always 6:00 pm on the deadline
date?

What I'm getting now for a missed deadline is: ############

Thanks for your help!!