Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
=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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Adding time | Excel Discussion (Misc queries) | |||
adding time | Excel Worksheet Functions | |||
Adding a Range | Excel Worksheet Functions | |||
Time log adding time from separate sheets | New Users to Excel | |||
Adding time to date-time formatted cell | Excel Discussion (Misc queries) |