1 Reply Latest reply: Feb 13, 2018 3:07 AM by Marcus Sommer RSS

    Rounding time down to nearest 30 minute Interval

    Eden Harson

      Hello,

       

      Does anyone know how to round down to the nearest 30 minute interval with date and time stamps?

       

      Ex :

      01/01/2018 07 :05 :00            to          07 :00 :00

      01/01/2018 07 :29 :00            to          07 :00 :00

      01/01/2018 07 :30 :00            to          07 :30 :00

      01/01/2018 07 :59 :00            to          07 :30 :00

      01/01/2018 08 :00 :00            to          08 :00 :00

       

      Thanks,

       

      Tsiry