vlookup time format

kelvin_9

Board Regular
Joined
Mar 6, 2015
Messages
238
Hi all, i have a question on time format when vlookup.
how can i easier to identify (conditional formatting with color or vlookup to return with my request only?) the table below if i want greater than 18:30(subject to change in A1)
18:45
21:30
17:15
16:30
21:00
19:45

<tbody>
</tbody>
ps: using cells format: [$-10409]h:mm
formula i use:
Code:
=IFERROR((VLOOKUP(A10,Sheet1!$Q:$V,6,FALSE)),"")
thanks all
 

Forum statistics

Threads
1,085,520
Messages
5,384,166
Members
401,885
Latest member
nirmalpatel85

Some videos you may like

This Week's Hot Topics

Top