AVg on time filed

[khadar]

Hi All,

Need small help on how to caliculate Avg on time field. Below is my case and I I wants show Avg on the time field.

can you please help me on this. I tried with AVG(Accept time) & AVG(q{<Accept time={">0"}>}Accept time) but no luck 

either of the cases i am getting result as 0

Accept time

00:00:34

00:00:38

00:00:41

03:00:43

04:00:56

05:00:54

06:00:34

[anat]

=Time(Avg([Accept time]))

[anat]

what is expected output?

=Time(Avg([Accept time]))

-- as per above 2:35:00,is it correct? 

[khadar]

Thanks for helping me out. Below is the filed and values have in excel doc. Business take avg on below field for them it got 00:00:38. I tried above logic answer is not coming. 

Accept Time

00:00:31

00:00:30

00:00:28

00:00:38

00:00:33

00:00:42

00:00:42

00:00:32

00:00:25

00:00:34

00:00:32

00:00:34

00:00:32

00:00:31

00:00:41

00:00:56

00:00:33

00:00:29

00:00:31

00:00:35

00:00:32

00:00:34

00:00:31

[anat]

=time(Avg(tt), 'hh:mm:ss') ,as per above data 00:00:34 is coming.

can u recheck ur expected output.

[khadar]

Sorry it's my mistake.

expected ouput is  00:00:38. instead of 00:00:34.

[anat]

if we calculate same in excel also getting 00:00:34

[khadar]

yes Anant, in excel it is getting 00:00:34. but not getting how business was caliculated this AVG 

[anat]

can you pls check with business user how they are calculating?

[khadar]

Sure Anant. I will check with  business. thanks for your help