Can an expert help me with a formula please, I have attached a file that hopefully will assist.
I need column T to either say Yes or No depending on the result.
Col L has a Day which populates when Sign Off date/Time is completed.
Col M has a Day [this is fixed].
Col N has a time [fixed]
Col O has a time [fixed]
Q and R are populated when Tick box in P is completed. [removed in this file]
Col S either Yes or No [with formula]
In col T I need formula that will say Yes or No based on:
If L & M are the same and the Time in Q is less than or equal to the time in O the answer in Col T is No
If L & M are the different and the Time in Q is less than or equal to the time in O the answer in Col T is Yes