C
Cathy
=F9+VLOOKUP(A9,time,2,FALSE)
In the formula above in cell H9 it is supposed to look at the time in cell
F9 and look at cell A9 and if A9 for example is Green in the name range are
Green represents 1.5 hours, then it will add 1.5 hours to F9 and give me that
in cell H9.
For Example
F9 currently read 9:00 am. So since Green is in cell A9 and Green is equal
to 1.5 hours long, then the formula should come back with 10:30 am. However,
it is not. So I am assuming that the reference in my named range area is
incorrect. Here is my name range area -
Red 1 (Should add 1 hour)
Purple 1.25 (Should add 1 hour & 15 mintues)
Green 1.5 (Should add 1-1/2 hours)
Brown 1.75 (Shoud add 1 hour and 45 minutes)
Yellow 2 (Should add 2 hours)
What is currently happening is I have 9:00 am and I am getting a returned
value of 9:00 am..
HELP .. and Thank you in advance
In the formula above in cell H9 it is supposed to look at the time in cell
F9 and look at cell A9 and if A9 for example is Green in the name range are
Green represents 1.5 hours, then it will add 1.5 hours to F9 and give me that
in cell H9.
For Example
F9 currently read 9:00 am. So since Green is in cell A9 and Green is equal
to 1.5 hours long, then the formula should come back with 10:30 am. However,
it is not. So I am assuming that the reference in my named range area is
incorrect. Here is my name range area -
Red 1 (Should add 1 hour)
Purple 1.25 (Should add 1 hour & 15 mintues)
Green 1.5 (Should add 1-1/2 hours)
Brown 1.75 (Shoud add 1 hour and 45 minutes)
Yellow 2 (Should add 2 hours)
What is currently happening is I have 9:00 am and I am getting a returned
value of 9:00 am..
HELP .. and Thank you in advance