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!
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!