You're welcome. Thanks for the feedback.


"Cathy" wrote in message
...
Thank you so much ... that worked perfect!

"Trevor Shuttleworth" wrote:

Cathy

Cell F53: =F52+VLOOKUP(D53,$A$1:$B$3,2,FALSE)/24

Regards

Trevor


"Cathy" wrote in message
...
I have named an area called employees. This is what the area looks like

A B
1 102 1.5 Hrs
2 105 2 hrs
3 108 1 hrs

In a different part of my excel sheet I am trying to find a formula
will
look in d5 and if A1 from above appears it will add that time, plus the
time
in the row above. Example

D E F
52 8:30 am
53 105 10:30 am
54 108 11:30 am
55 102 1:00 pm

So in other words, I entered a start time of 8:30 am. In F53, the
formula
look at D53 and since 105 is 2 hours in the named area, the formula
added
2
hours to the time from the cell above.

I hope this make sense. And I really could use this help ASAP.