Forum Discussion
Date and Time Formula Help
I'm using the following formula to determine whether the actual delivery time of a Tray was achieved at or before the scheduled delivery time. =IF(AND($N41677<=$J41677,$N41677<>""),"Y",IF($N41677="...
I cannot reproduce the problem:
Could you attach a small sample workbook that demonstrates the problem, without sensitive/proprietary information?
- Thank you, I realized the problem. I didn't have the cells in a "time" format and it wasn't comparing them appropriately. Once I changed the cells to a "time" format, the formula worked.
