Time question

[Cesar Zapata]

help please.

im using a vlookup method to mach if someone works at specific time for
example if cesars is next to 5:00 AM then it works but ovbiosly it does
not work if cesar is schedule from 5:15 or 5:30. is there a formula that
can check the whole hour? one idea is to use < > but i wonder if there
is an more efficient way.



thanks

 

[Peo Sjoblom]

You could use

=INDEX(D49,MATCH(HOUR(A1),HOUR(C4:C9),0))

entered with ctrl + shift & enter

it would be the same as

=VLOOKUP(A1,C49,2,0)

it will round down to nearest hour thus a time like 05:45 will match 05:00
where it won't using vlookup.