title: Formula required for inserting cut-off time
body: <p><img src="https://i.stack.imgur.com/p1FKa.png" alt="enter image description here"></p>
  
  <p>I am developing an excel where timestamp needs to be added and if the timestamp goes beyond the specific time, then it should return a value says "Late" or else it should return "On-Time"</p>
  
  <p>I tried 3 formulas but none of them works if the cut-off time is specified.</p>
  
  <pre><code>=IF(C2&lt;TIME(5,10,0),"On-Time",IF(C2&gt;=TIME(5,10,0),"Late","0"))
  
  =IF(AND(C18&gt;TIME(12,0,0),C18&lt;TIME(12,0,0)),"Late","On-Time")
  
  =IF(C2&lt;E2,"On-Time","Late")
  </code></pre>
  
  <p>Please help me</p>
  
  <p>"C" column is the place where timestamp is stamped. It is linked to sheet 1 where it is actually stamped and this is the backend sheet. Refer the image and E2 is for cut-off time. </p>