Difference in Time and also average

[rohit782192]

How can we calculate the Difference and the average between the rows,

Time

08:01:00

08:02:18

[Jay-RDC]

You can first use cross tab to convert to horizontal rows then use formula tool datetimediff. Use Summary tool for the average. 

[Ladarthure]

Hello @rohit782192,

you could do this by using a multi row formula (it allows you to reference the previous line): it would look like something like this :

DateTimeDiff([Time], [row-1:Time], ‘seconds’)

you can then use a summarize to calculate the average

[rohit782192]

It give me a Message . Malformed Function call.

[Jay-RDC]

Make sure to check on the data type. Use a select tool to verify how it's reading the data. It should be reading it as date time format before using the formula.