1 Reply Latest reply: Nov 4, 2017 2:32 AM by Petter Skjolden RSS

    How to calculate the EnquiryEndTime based on EnquiryDateTime + Duration field?

    Michael Wallman

      Hello all,

       

      I have some sample data that looks like this:

       

         

      EnquiryIDCallDateTimeEnquiryDuration(Seconds)
      232323232322/06/2017 23:32:57254.8

       

       

      I need to calculate the end time based on the two fields above.

       

      The EnquiryDuration field values range from a few seconds to hours.

       

      How can I calculate and add the EnquiryDuration value to the CallDateTime field and create a CallEndTime field please?