Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup working days
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to calculation no. of days (only working days) between two dat | Excel Discussion (Misc queries) | |||
Non working days | Excel Discussion (Misc queries) | |||
5.5 working days | Excel Discussion (Misc queries) | |||
Working days | Excel Discussion (Misc queries) | |||
Working Days | Excel Discussion (Misc queries) |