1 2 3 Previous Next 35 Replies Latest reply on Apr 19, 2018 12:47 PM by Dan Dan

    Create 15 minutes time interval

    Gurpreet Singh Goraya

      Hello All,

       

      I need to create15-minute intervals specifically from 500 hrs - 2400 hrs (500-515, 515-530 and so on). I am able to have an hour time interval but could not figure out to how to create it for 15 minutes. Please advise. Here is the calculated field for an hour time interval.

       

      STR(INT(LEFT([Negtime],2))) + " to " + STR(INT(LEFT([Negtime],2))+1)

       

      Thanks

       

        1 2 3 Previous Next