3 Replies Latest reply: Apr 11, 2016 5:36 AM by Sunny Talwar RSS

    How to assign time buckets from a datetime

    Arjin Ram Korrapati

      Hi,

       

      I need to create to time buckets using time from the Date-time filed , buckets required are as below, time is in 24 hour format, pls help

       

      Time Bucket
      <8:30AM
      8:30AM-9:30AM
      9:30AM-10:30AM
      10:30AM-11:30AM
      11:30AM-12:30PM
      12:30PM-1:30PM
      1:30PM-2:30PM
      2:30PM-3:30PM
      3:30PM-4:30PM
      4:30PM-5:30PM
      5:30PM-6:30PM
      >7:30PM
      WKEND

       

      Thanks in advance

      Ram.