LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 104
Default Adding Time from Name Range

=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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding time Gringarlow Excel Discussion (Misc queries) 2 November 28th 07 03:36 PM
adding time GrayC011182 Excel Worksheet Functions 2 June 4th 07 08:33 PM
Adding a Range Joey041 Excel Worksheet Functions 1 November 21st 06 09:23 AM
Time log adding time from separate sheets teastman New Users to Excel 1 December 31st 05 04:14 PM
Adding time to date-time formatted cell tawtrey(remove this )@pacificfoods.com Excel Discussion (Misc queries) 4 August 12th 05 10:53 PM


All times are GMT +1. The time now is 09:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"