VLOOKUP Time Error

[MoOsEBoT88]

Hi,

I am looking to return the planned activity for the current hour for that Bay

So at 10:32am it should rounddown the 10:00 and show whats planned in for that bay for 10:00 - 10:59

I have this formula but its returning the wrong result.

=VLOOKUP(FLOOR(NOW(),1/24),Plan!A2:B14,2,TRUE)

Hope someone can point me in the right direction.

 

[Peter_SSs]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Try this, but there may still be some rounding issues. If still problems, can you post what you have in Plan A2:B14 with XL2BB?

=VLOOKUP(MOD(FLOOR(NOW(),1/24),1),Plan!A2:B14,2,TRUE)

 

[MoOsEBoT88]

Thanks this works, I have updated my account also. Its been awhile.

 

[Peter_SSs]

Cheers, glad it worked for you.
.. and thanks for updating your profile.

In case you were wondering, the issue is that NOW() includes today's Date and Time. The date needed to be removed to just look up the time.