| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically Adding Time based on a name ranged
I have a named range ---
178 1:45 5969 2:00 48 1:30 The table I am working looks like A B C D 178 Contract A 2/3/08 8:00 am 5969 Contract A 2/3/08 9:45 am 48 Contract B 2/3/08 11:45 am In column D row 1 , I would input a time. In column D row 2, the formula would look at column A row 1, and match it up in the named range, then add those hours and minutes to column D row 1 time and give me a new time. HELPPPPPPPPPPPPPP! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Automatically Adding Time based on a name ranged
In d2, use:
=d1+vlookup(a1,$NamedRange,2,false) Regards, Fred "Cathy" wrote in message ... I have a named range --- 178 1:45 5969 2:00 48 1:30 The table I am working looks like A B C D 178 Contract A 2/3/08 8:00 am 5969 Contract A 2/3/08 9:45 am 48 Contract B 2/3/08 11:45 am In column D row 1 , I would input a time. In column D row 2, the formula would look at column A row 1, and match it up in the named range, then add those hours and minutes to column D row 1 time and give me a new time. HELPPPPPPPPPPPPPP! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Named ranged selection problem | Excel Worksheet Functions | |||
| Enter text automatically based on current time | Excel Discussion (Misc queries) | |||
| Adding multiple data fields from time based data. | Excel Discussion (Misc queries) | |||
| Adding time to date-time formatted cell | Excel Discussion (Misc queries) | |||
| Vlookup - Using a named ranged for col_index_num | Excel Discussion (Misc queries) | |||
Linear Mode
