Time formula result wrongly expressed as a fraction in cell formated to "Time"

[Ruthanne]

Hi all, Thank you in advance for your wonderful help!
I couldn't find an answer "anywhere" to the following problem:
I have the following Vlookup formula:
=VLOOKUP($B$4,input!E3:Y400,5,FALSE)&" - "&(VLOOKUP($B$4,input!E3:Y400,6,FALSE))
It is in a cell that is formatted to time. It is pulling data from cells formatted to time. (This formula is supposed to display the start & end of employees' lunch periods, i.e. 11:30 - 12:00.)
However, the formula result reads "0.479166666666667 - 0.5" instead.
Can anybody crack this nut? (the formula results used to display properly until I started "improving" the file today!)
Thanks again!

 

[lenze]

Try

=TEXT(VLOOKUP($B$4,input!E3:Y400,5,FALSE),"hh:mm")&" - "&TEXT(VLOOKUP($B$4,input!E3:Y400,6,FALSE),"hh:mm")

lenze

 

[Ruthanne]

It worked! Yippee!!!!! Thanks Lenze...you're swell!