aaahhhhhhhhh
Sorry but Im frustrated - why isnt it working !!!

"Matt Lunn" wrote:

Hi,

You could also use this if the time you wish to check against is in cell A1

=IF(A1TIME(17,30,0),TRUE,FALSE)

ThaNKS


"ynissel" wrote:

How do I write an if statement to check if its past 5:30 PM. I tried
if(hour17.5) but that only checks the hr itself and not minutes.
Thanks,
Yosef