Hi Frank,
To make this formula work, you need to enclose the time in quotes and use the
function to specify the time. Here's the corrected formula:
- =IF(K2="","",IF(K2<TIME(15,30,0),"Yes","No"))
This formula checks if the cell in column K is blank. If it is, it returns a blank cell. If it's not blank, it checks if the time in that cell is earlier than 3:30 pm (which is represented by the
function with 15 hours and 30 minutes). If it is, it returns
"Yes". If it's not, it returns
"No".