Thanks for the reply, but the formula can still compute answers which are out
of hours.

"Mike H." wrote:

Try this:

=LOOKUP(I38,{1,2,3,4,5},E38+{0.0833333333333333,0. 166666666666666,1,2,7})+(IF(WEEKDAY(E38)=6,2,IF(WE EKDAY(E38)=7,1,0)))


"DaveAsh" wrote:

Hi,
I have a column set up with a drop down menu listing the priority of a
job(1-5). I have another column set up which gives the predicted finish date
of the job as dd/mm/yyyy hh/mm. I have made a function with lookup that
gives the predicted finish date when any one of the 1-5 are chosen.

1 priority takes 2 hours
2 4 hours
3 1 day
4 2 days
5 1 week

This is the formula i have used:
=LOOKUP(J38,{1,2,3,4,5},E38+{"0.083333333333333333 333333333333333","0.166666666666666666666666666666 67","1","2","7"})

How can i adjust it to take into account working days (mon-fri 9am-5pm)

Thanks.