# Need to check if the current time is greater than today at 6pm

1. ## Need to check if the current time is greater than today at 6pm

How would I check if the current time is greater than the current date at 6pm?

So example:

if (Now() is greater than "12/11/2014 6:00 PM") then set the column to 1, if less than that... 0

Now sure how to set the current date etc in the formula.

2. ## Re: Need to check if the current time is greater than today at 6pm

=HOUR(NOW()) will give you the hour now, so =if(HOUR(NOW())>=18,1,0) should work

3. ## Re: Need to check if the current time is greater than today at 6pm

here is a solution
Formula:
`Please Login or Register  to view this content.`

4. ## Re: Need to check if the current time is greater than today at 6pm

Okay,

I guess I need something a little different. I have a column that has a date: "12/6/2014" and I need to check off of that date. So if Now() is greater than date of column A6 at 6pm then put a 1, other wise put 0.

If("12/6/2014 6pm" < Now(), 1, 0)

So how can I add 6pm to the date of column A6 etc?

There are currently 1 users browsing this thread. (0 members and 1 guests)