15 mints time difference need to identify

[Anonymous]

Hi

I have a field which is capturing  invoice time daily basis like  this 10.30.22, 10.40.21,

My requirement is need to identify the 15 mints time difference in the invoice time field.

Example:   first row           11.30.22 ,

                second row       11.45.40  

i need to get the difference like this 00.15.18  

How can i achieve this kindly help me

Thanks in Advance..

Siraj

[hic]

Make sure that the timestamps are ordered, and use

Load

     Time#( TimeStamp, 'hh.mm.ss' ) as Time,

     Time(Peek(Time) - Time#( TimeStamp, 'hh.mm.ss' )) as Diff,

HIC

[danieloberbilli]

PFA the qvw

[amit_saini]

Hi,

Check :

http://community.qlik.com/message/265494#265494

Thanks,
AS

[Anonymous]

Hi

Thanks for your answer

i here attached my sample data can you kindly help me to fix this in my file

please find the attachment.

[danieloberbilli · Accepted solution]

PFA

Kind Regards

Daniel

[Anonymous]

Thanks lot...

working fine..