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

    Time difference in an if statement

    Jo 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

      Jo