Average Time

[noman212]

How to calculate average time between 2 row?

Please find the attached scenerio....

[ecolomer · Accepted solution]

Hi,

First calculate the difference between (use function ABOVEpar example) two dates / hours and transform to minutes

then, you divide by two result (minutes) and then adds obtained minutes the first of the dates / times

[MarcoWedel]

Timestamp(Numavg(timestamp1, previous(timestamp1)))

?

hope this helps

regards

Marco

[jyothish8807]

Hi Noman,

Try this

Timestamp(Numavg(timestamp1, previous(timestamp1)),'MM/DD/YYYY hh:mm:ss')

Regards

KC