Trevor,

I am having a hard time coming up with exactly the number to put in A1:B7 so
the time that calculates in F53 in some cases, is 1:05 hours later then the
time in F52. Do you know number I can put in. Here is an example of what I
have in A1:B7 now -
1 102 1.50 (adds 1-1/2 hours to time)
2 105 2.0 (adds 2 hours to time)
3 108 1.0 (adds 1 hour to time)
4 110 1.25 (adds 1:15 hours to time)
5 109 1.05 ........... this the number I need help
with. It just add 3 minutes to the time. I have tried using various numbers
and it is not consistant.



"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.