6 Replies Latest reply on Mar 1, 2016 2:40 AM by thimmaraju.madugundu

    Adding minutes time to the existing date

    thimmaraju.madugundu

      Hi,

       

       

      I have data which belongs power meter readings, Every meter will have 96 records along with date stamp. But I wanted to create another field which should display Date and time stamp as mentioned below format and it should d running sum of 15 minutes as mentioned examples.

       

       

      Existing Data:

       

       

      2/29/2016 00:00:00 AM

      2/29/2016 00:23:00 AM

      2/29/2016 00:56:00 AM

      2/29/2016 01:10:00 AM

      2/29/2016 02:28:00 AM

       

       

      And I am looking forward to get the data in the below format of 96 records.

       

       

      2/29/2016 00:15:00 AM

      2/29/2016 00:30:00 AM

      2/29/2016 00:45:00 AM

      2/29/2016 00:60:00 AM

      2/29/2016 01:15:00 AM

      2/29/2016 01:30:00 AM

      2/29/2016 01:45:00 AM

      2/29/2016 01:60:00 AM

      2/29/2016 02:15:00 AM

      2/29/2016 02:30:00 AM

      .....

      2/29/2016 11:45:00 PM

      and so on till of 96 records. Every hour has 4 records.