Adding Time from Name Range

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
 
L

Luke M

You are adding integers and time! In XL, time is actually a decimal number.
For example, 2 = 1/2/1900 12:00 AM

In your table, input the time you want to add as time (e.g. 1:00, 1:15,
1:30, 1:45, 2:00)
XL will automatically recognize these as time values, convert to decimal,
add it to your other time value in F9, and display the result (again, in time
format).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top