View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default If Statements With Time of Day

=IF(G2<=TIME(13,0,0),"Acceptable","Not Acceptable")

"JB" wrote:

I want to create an if statement that says:

If G2 is less than or equal to 1:00 PM then return "Acceptable" and if it is
greater than 1:00 PM return "Not Acceptable"

Thanks for the help!