Differance in Time

[soniasweety]

Hi all,

I want to calculate the time difference  ,I have a filed like below

opendate ,and I need a new column I like  (current time- openeddate )  How to calculate?

May be small issue but am new to Qlik

OpenDate

7/5/2017 11:16

7/5/2017 21:12

7/5/2017 19:10

7/5/2017 21:12

7/5/2017 21:12

6/29/2017 10:15

6/29/2017 10:27

6/29/2017 10:28

[ahaahaaha]

Hi,

As variant at attached file

[soniasweety]

thanks all for your inputs 

I will check all the possibilities.

Thanks

Sony

[dberkesacn]

maybe you can close the topic by choosing one of the answer as a Correct one.

[soniasweety]

sure Daniel.thanks