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

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



      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)