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

[#1]

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 Created	Date Resolved
01-01-16 1:01 AM	02-01-16 4:01 AM
01-01-16 2:01 AM	03-01-16 5:01 AM
01-01-16 3:01 AM	04-01-16 6:01 AM

Thanks in advance!

(This is all on QlikSense NOT Qlik View)

[maxgro]

avg(Timestamp#([Date Resolved], 'DD-MM-YY HH:SS TT') - Timestamp#([Date Created], 'DD-MM-YY HH:SS TT'))

[Vegar]

If you put interval() around maxgro‌'s expression it will be presented in a readable format.

Interval( avg(Timestamp#([Date Resolved], 'DD-MM-YY HH:SS TT') - Timestamp#([Date Created], 'DD-MM-YY HH:SS TT')) )

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

[Anil_Babu_Samineni]

Would you let me know what is the expected output for it