3 Replies Latest reply: Nov 5, 2016 9:28 AM by Anil Babu Samineni RSS

    How to use this date/time format then work out the difference.

    Aaron Phelan

      Hello,

       

      So I have a CSV which auto exports as DD-MM-YY HH:SS TT. (01-01-16 11:01 PM).

       

      I have two time fields, Date created and date resolved - I want to be able to work out the average difference between these.

       

      Here is an example of my table

       

      Date CreatedDate Resolved
      01-01-16 1:01 AM02-01-16 4:01 AM
      01-01-16 2:01 AM03-01-16 5:01 AM
      01-01-16 3:01 AM04-01-16 6:01 AM

       

      Thanks in advance!

      (This is all on QlikSense NOT Qlik View)