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. I am trying to make this function automated to give the predicted
finish date when any one of the 1-5 are chosen.

1 prority takes 2 hours
2 4 hours
3 1 day
4 2 days

How can i achieve this function?