Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup with time
I am trying to do a Vlookup using time. Whenever I reference the cell in the
formula that contains the time I want to look up, it converts the time into a number (e.g. 8:40 a = .36111...) and will not look up properly in the array table. I have formatted the lookup value as a time. Not sure what else to do. Thanks! -CRM |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup with time
You're correct that a time of 8:40am equals .36111... This is how Excel
stores times (times are fractions of a day). So it won't be your problem. The likely problem is that your lookup value is stored as text, not time. What happens when you reformat this value as General. Do you see .36111? If not, you've got text. To convert text to times, Text to Columns is the easiest way. Regards, Fred. "blueriver" wrote in message ... I am trying to do a Vlookup using time. Whenever I reference the cell in the formula that contains the time I want to look up, it converts the time into a number (e.g. 8:40 a = .36111...) and will not look up properly in the array table. I have formatted the lookup value as a time. Not sure what else to do. Thanks! -CRM |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup between two time stamps | Excel Worksheet Functions | |||
Vlookup.... 2nd time | Excel Worksheet Functions | |||
VLookup and HLookup at the same time | Excel Worksheet Functions | |||
time formatting and time categorizing (vlookup or data validation) | Excel Worksheet Functions | |||
time formatting and time categorizing (vlookup or data validation) | Excel Worksheet Functions |