7 Replies Latest reply: May 29, 2013 10:14 AM by David Ambrozie RSS

    Round to closest half hour?

    Robert Svebeck

      Which is the most simple way to (in the load script) to do a rounding of a timestamp field (hours:minutes) into "segmensts" like this:


      Origin Rounded
      11:39  11:30
      01:34  01:30
      03:11  03:00
      05:43  05:30
      03:27  03:30
      06:16  06:30
      03:54  04:00


      Regards


      Robert Svebeck