Hours Elapsed based on todays date

[Anonymous]

Hi Experts

Not sure if the following mesure will give me what i need ( i am not after the average time, but actual time). I am trying work our the number of hours that have elapsed based on todays date and based on the created on date in the sample data below...

Measure = Averagex(
T,

VAR created_ = T(Created on)
VAR Now_ = Now()

Var SecondsPerHour = 60 * 60
Return
DateDiff(Second, Created_,Now_) 

Record ID	Created On	Elapsed Time Hours
1	4/7/2021 07:10:56am	98.1
2	30/4/2021 5:55:10pm	32.4
3	5/1/2021 2:42am	8.3

[amitchandak · Accepted solution]

@Anonymous , seem fine, A measure like 

Averagex(Table, datediff([Created On], now(), second)/3600.0 )

or a column

datediff([Created On], now(), second)/360.0