Calculating time between Two time stamp

[#1]

hey guys I am new to qlikview .

Can you please help me to calculate the no of working days,hours , minutes , to close the case.

Ticket No	Case Created	Case Closed	User
01/01/1900	19/11/2014 11:45	29/11/2014 12:45	abc1
02/01/1900	19/11/2014 16:30	19/11/2014 17:30	abc2
03/01/1900	24/11/2014 11:45	27/11/2014 12:45	abc3
04/01/1900	19/11/2014 08:30	19/11/2014 11:30	abc4
05/01/1900	22/11/2014 14:30	24/11/2014 15:30	abc5
06/01/1900	19/11/2014 19:15		abc6

[tresesco]

Try interval()

[#3]

Hi,

you can try the below format, in which the vale return are the number of days

interval( A-B, 'D hh:mm' ) where A=97-08-06 09:00:00 and B=96-08-06 00:00:00 returns:

String	365 09:00
Number	365.375

see Qlikview help for further explanation

with regards

Harshita Gaur