topic Re: AVg on time filed in App Development

AVg on time filed

khadar — Wed, 12 Jan 2022 04:58:08 GMT

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

Re: AVg on time filed

anat — Wed, 12 Jan 2022 06:12:04 GMT

=Time(Avg([Accept time]))

Re: AVg on time filed

anat — Wed, 12 Jan 2022 06:13:12 GMT

what is expected output?

=Time(Avg([Accept time]))

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

Re: AVg on time filed

khadar — Wed, 12 Jan 2022 09:05:03 GMT

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: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

Re: AVg on time filed

anat — Wed, 12 Jan 2022 09:36:07 GMT

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

can u recheck ur expected output.

Re: AVg on time filed

khadar — Wed, 12 Jan 2022 09:54:12 GMT

Sorry it's my mistake.

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

Re: AVg on time filed

anat — Wed, 12 Jan 2022 09:57:57 GMT

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

Re: AVg on time filed

khadar — Thu, 13 Jan 2022 07:48:33 GMT

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

Re: AVg on time filed

anat — Mon, 17 Jan 2022 03:05:52 GMT

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

Re: AVg on time filed

khadar — Tue, 18 Jan 2022 13:50:58 GMT

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