Calculating the average of the time

[Feras95p]

Dear all,

I have a column which contains the rows of times formatted hh:mm and I want to calculate the average of that column. How can I do that?

Any help in that please?

Thanks in advance for your kind support.

[treepruner]

I think you will have to convert the elapsed time into seconds, then average seconds, then convert back into hours and minutes.

Sarah

[Qiu · Accepted solution]

@Feras95p 

Somehow it is strange Alteryx does not have the convinient function for Time Average like Excel.
Appreciate if you would mark it as accept if you find it useful for you.

[rohit782192]

It is throwing me an Error.