I have a begindate and enddate in my report. When I have an expression enddate-begindate in a timedifference column, it shows perfectly as 00:11:16 in the format hh:mm:ss.
Now I need to add an average column. And I am not able to convert 00:11:16 to string or any other datatype so I could use split expression to get the individual parts and calculate total number of average seconds. If I am able to get average seconds, I can convert to hh:mm:ss format bu using a format function.
Could anyone please help me on this one. Is there a way to find the average time difference? I hugely appreciate a quick response. I have been stuck with this for hours. I don't want to change my data query, as it is very complex.