Be aware that if the cell contains a date and time, but is
formatted to display only time, the formula will always return
"Not Acceptable".
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"Toppers" wrote in message
...
=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!