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.
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.
=HOUR(NOW()) will give you the hour now, so =if(HOUR(NOW())>=18,1,0) should work
here is a solution
Formula:Please Login or Register to view this content.
Regards,
Vikas Gautam
Excel-buzz.blogspot.com
Excel is not a matter of Experience, its a matter of Application.
Say Thanks, Click * Add Reputation
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)
Bookmarks