Average of time difference

[charlotteeik]

Hi,

How can I find the average per date for the difference between Earliest and Latest RegTime? 

You can see the measure I used to calculate the difference between Earliest and Latest RegTime. 

Hope someone can help me with this issue! Thanks,

[Anonymous]

You can add a new measure which stores the Difference in Decimals only.

TimeDifference (in Decimals)

Then create a new measure to compute the Average of this and Format it

Average TimeDifference = 

_avg = AVG(TimeDifference (in Decimals))

var _hrs = _avg * 24

var _mins =  (_hrs - int(_hrs)) * 60

var _sec =  (_mins - int(_mins)) * 60

return FORMAT(int(_hrs), "#00") & ":" & FORMAT(int(_mins), "#00") & ":" & FORMAT(int(_sec), "#00")