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.