3 Replies Latest reply on Oct 7, 2018 11:36 PM by Amit Srivastava

    Time Difference Calculated Field

    Joseph Maier



      I am having trouble trying to create a calculated field that generates the time difference between these two columns.



      So for instance the new calculated field column would look for if the BatchEndTime value is not null then the "4/25/2018 7:12:50 PM" time would have the "4/25/2018 7:12:12 PM" subtracted for it. The problem I'm having is that I don't know how to access the the connected BatchStartTime date when I'm in a row where a BatchEndTime is present.


      Any help is appreciated. Thanks!