Lookup function to take into account working days only

D

DaveAsh

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.083333333333333333333333333333333","0.16666666666666666666666666666667","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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding IF function to Lookup??? 3
Lookup working days 2
Vlookup to account for working hours mon-fri (9-5) 2
NOTHING WORKS2-HELP 6
How to calculate difference between two date & time along with working hours and days 2
Calculating days spent to complete a task 2
Compute Additional Hours Needed Using "if" or "lookup" 1
number or working days 6

Top