Try

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


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"JB" wrote in message
...
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!