8 Replies Latest reply on Nov 30, 2018 11:24 AM by Jessica Singer

    Round time to nearest hour, split at 30 minutes

    Jessica Singer

      Looking for a calc that will let me round into hour bins, but with say, 4:17 rounded to 4:00, and 4: 47 rounded to 5:00.

       

      Looked here: DATETIME() for rounding or truncating to nearest time interval

      and here: Rounding time down to nearest 30 minute Interval

       

      and it seems I'd need to combine them in some way. But I don't understand date functions well enough to pull the calcs apart and use the pieces I need.

       

      Please help!