1 Reply Latest reply: Jun 5, 2017 1:00 AM by Tresesco B RSS

    Time difference in an if statement

    Josephinet Tedesco

      Hi I have these timestamps:


      Apt DateArrivalApt TimeStartTime
      Fri 02/06/201708:1408:1508:21

      My formula for Arrival time - Aprt Time


      interval(ArrivedTime - AptTime , 'hh:mm')

      I have formatted the answer to General:


      I want to show if the person arrived before the AptTime to show EARLY or LATE

      if(interval(ArrivedTime - AptTime, 'mm')  >= 0, 'Early')  (Early works but all other values are blank)


      Would it be possible to show if the ArrivedTime was within 10 mins either way of the AptTime???


      thank you