Check if a time is past a certain time
 

If i have a time entered in a cell say A1, how can i check if the time
is past a certain time say 5:00pm using an if statement?
thanks

Check if a time is past a certain time
 

Or how can i check if the current time is past a certain time say 5pm?

Check if a time is past a certain time
 

On Sat, 31 Jan 2009 13:23:42 -0800 (PST), Savio
wrote:

Or how can i check if the current time is past a certain time say 5pm?

Try this:

=IF(MOD(NOW(),1)TIME(17,0,0),"later than 17","not later than 17")

Hope this helps / Lars-Åke

Check if a time is past a certain time
 

=IF(HOUR(A1)=17,"5 PM or later","Not yet 5PM")

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

On Sat, 31 Jan 2009 13:12:59 -0800 (PST), Savio
wrote:

If i have a time entered in a cell say A1, how can i check if the time
is past a certain time say 5:00pm using an if statement?
thanks