2 Replies Latest reply: Nov 8, 2017 2:48 AM by Shahzad Ahsan RSS

    How to calculate time difference

    Shahzad Ahsan

      Hello Everyone

      I want to calculate time difference.

      It is calculating right but if the date is changed then it has problem.

      You can see the second last row from the snapshot.

      I have 4 fields in database startdate, starttime, enddate, endtime.

       

      I want result 3:00 in second last row.

      I have used this

      =Interval (endtime - starttime, 'hh:mm')

       

      Screenshot.jpg