The following IF statement will not return true. I have tried it a s a formula also and the problem seems to be the hh:mm:ss formatting. Although the cell value in column F reads as "00:15:00" it will never return true such that cell value in G becomes "Auto close".The following IF statement will not return true