ExcelBanter - Comparing specific date and hour with NOW()

I'm creating a position table for a cup, the games are all played at a
specific date and time(usually they finish around 5:30 pm.)

The problem I'm having is that I want to add 1 to the "Games Played"
column after the date and hour when that game is played, and I don't
know how. The date part is easy I just do:

ADD(IF(B11<=TODAY();1;0).....)
Where B11 has DATE(2006/07/12)

The problem with this is that pryor to the game at 3:45 pm the stats
will be messed up. I just want to get it as perfect as possible.The
main issue I'm having is with adding the hour to the comparison. I've
tried using NOW(), but still can get the hour on the other side to be
compared.

Can anyone help me? How can I compare a given date and hour on a cell
with the "actual" date and hour from the PC? Keep in mind that diferent
dates and times are scheduled on different cells for different legs of
the competition.

Thanks in advance.

--
Memoman
------------------------------------------------------------------------
Memoman's Profile: http://www.excelforum.com/member.php...o&userid=36399
View this thread: http://www.excelforum.com/showthread...hreadid=561770