=IF(J38<3,IF(J38=1,E38+TIME(2,0,0)+(MOD(E38,1)=TI ME(15,0,0))*TIME(16,0,0),E
38+TIME(4,0,0))+(MOD(E38,1)=TIME(13,0,0))*TIME(16 ,0,0),WORKDAY(E38,LOOKUP(J
38,{3,4,5},{"1","2","7"})))

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"DaveAsh" wrote in message
...
Hi I have set up a lookup formula to calculate the projected finish time
for
a job in the format dd/mm/yyyy hh:mm , this is:


=LOOKUP(J38,{1,2,3,4,5},E38+{"0.083333333333333333 333333333333333","0.166666
66666666666666666666666667","1","2","7"})

E38 is the date/time that the job was logged
J38 is the prority status (1-5)

The priority status related to:
1-completion should be within 2 working hours
2-" " " " " 4 working hours
3-" " " " " 1 day
4-" " " " " 2 days
5-contact should be within 2 days

How can i add to the formula using =if to make the formula not give days
which are weekends or out of hours (after 5pm to 8.59am)

Thanks.