Yes, sorry for the confusion. I need it to take into account that people
don't work past 5pm daily.

Hope you can help.

"Mike H." wrote:

"Out of Hours" What does that mean? Are you saying you need to take into
account that people don't work past 5pm daily? Your formula has never taken
that into account. Is that what you need to do. For example, if at 4 pm,
they have a priority 1, (2hrs), then it would finish at 10 am the next day,
assuming both days were weekdays. Let me know. I am sure if this is what
you want and I am sure that it can be accomplished.

"DaveAsh" wrote:

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.