4 Replies Latest reply on Nov 10, 2019 1:45 PM by Vinay Seeruthun

    Time comparisons

    Vinay Seeruthun

      Hi there,

       

      Can anyone help me with time comparisons. I'm trying to group my times into 15 minute intervals but i'm getting the error below:

       

      Untitled.png

       

      IF [Actual Entry Time] >= #00:00:00# AND [Actual Entry Time] <= #00:15:00# THEN #00:15:00#

      ELSEIF [Actual Entry Time] >= #00:15:00# AND [Actual Entry Time] <= #00:30:00# THEN #00:30:00#

      END

       

      Thanks