1 Reply Latest reply on Dec 28, 2017 1:53 AM by Norbert Maijoor

    Subtract a particular column of one row from another

    Shantam M

      My data looks like

       

      Workflow NameServer   IdStart   TimeEnd Time
      wf_JOB_END219/8/2017 13:299/8/2017 14:29
      wf_JOB_START179/8/2017 13:129/8/2017 13:25
      wf_JOB_START179/6/2017 13:079/6/2017 13:24
      wf_JOB_END219/6/2017 13:289/6/2017 14:28
      wf_JOB_END219/10/2017 12:489/10/2017 13:48
      wf_JOB_START179/7/2017 12:399/7/2017 12:47
      wf_JOB_END219/7/2017 12:509/7/2017 13:50
      wf_JOB_END219/11/2017 12:549/11/2017 13:55
      wf_JOB_END219/9/2017 12:479/9/2017 13:47
      wf_JOB_START179/11/2017 12:399/11/2017 12:50
      wf_JOB_START179/10/2017 12:389/10/2017 12:45
      wf_JOB_START179/9/2017 12:389/9/2017 12:44
      wf_JOB_START179/12/2017 12:409/12/2017 12:48

       

       

      Basically what I am looking is to find the total runtime for this job i.e.

       

      [Start time of wf_JOB_START] - [End Time of wf_JOB_END] = Duration

       

      Is this possible ?

      Attaching excel sheet for reference