Difference Between Consecutive Time ????

[#1]

Hi all,

I need to have difference between two consecutive dates of the same column.

I am trying the expression as  (login time)-above (login time), still getting no success.

Any sort of help in same is appreciated.

Sample excel file has been attached for reference.

Thanks

Mayank

[kumarnatarajan]

Hi,

Please find the attached file.

Script:

Temp:

LOAD * INLINE [
    Login Time
    5/2/2013 8:18:05 AM
    5/2/2013 8:18:31 AM
    5/2/2013 10:18:06 AM
    5/2/2013 10:18:09 AM
    5/2/2013 10:24:28 AM
    5/2/2013 11:11:10 AM
    5/2/2013 11:11:13 AM
    5/2/2013 11:15:24 AM
    5/2/2013 4:45:35 PM
    5/2/2013 4:45:38 PM

];


NoConcatenate LOAD [Login Time],Interval([Login Time]-Previous([Login Time])) as Difference Resident Temp;
DROP Table Temp;

[fdelacal · Accepted solution]

PLEASE SEE QVW ATACH

HOPE THAT HELPS YOU REGARDS.

THE FIELD DIFERENCA IS I CREATE WITH THE DIFERENCES