7 Replies Latest reply on Oct 9, 2018 8:44 AM by kausalya durgale

    Datediff between two columns

    kausalya durgale

      Hi- I am trying to calculate the difference between two dates as per below example:


      my first job CHD***221 starts on 14/09/2018 11:58:00PM and my last job is CHDP0783 end on 15/09/2018 5:56:00AM, I would like to calculate difference between these 2 dates. similarly it follows the pattern..from next rows 15/09/2018 11:50:00PM- 16/09/2018 7:56:00AM

      16/09/2018 11:50:00- 17/09/2018 6:59:00AM