Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
PFA the qvw
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.
PFA
Kind Regards
Daniel
Thanks lot...
working fine..