Sheet G How to obtain an average duration?

I have a duration series which is also the result of a formula in a column formatted in duration

Duration :
80:08:00
53:05:00
50:20:00
86:21:00
59:56:00
44:27:00
#VALUE!
35:44:00
39:29:00
133:45:00
35:07:00
32:20:00
.../...

I would like to get the MIN, MAX and AVERAGE values. For the average I tried this formula

=ARRAYFORMULA(AVERAGE(TIMEVALUE(E2:E305)))

I have this error:

#VALUE! ERROR TIMEVALUE parameter '' cannot be parsed to date/time

How to exclude the cell with no value inside?

The Democrats got $ 75 million to go to the PBS and the NPR in Bill COVID-19. Can the average unemployed American appreciate their decision?

I do not

The Democrat's shopping list …. not a complete list ———>

$ 300 million for public broadcasting.

New emission standards for airlines and a requirement for full carbon offsetting by 2025.

Registration required the same day and early voting.

Government funded pension plans for community newspapers.

A $ 1 billion "Cash for Clunkers" style program in which the government purchases garbage planes from airlines.

$ 1.5 million to study climate change mitigation efforts in the civil aviation and aerospace industries.

New and binding OSHA requirements for hospitals.

$ 1 billion for taxpayer-funded cell phones.

mysql – hello, it shows me the current stock of the year 202001, how can i make it show me the current stock of the year 202002 with the average

```

displays current_stock for the year 202002 and not 202001 next to the average as indicated in the query


CREATE DATABASE PRUEBA;
use prueba;
create table consumos(
id_consumos int primary key auto_increment,
annomes varchar(6),
cod_establecimiento varchar(5),
cod_med varchar(5),
consumo int,
stock_actual int
);


insert into consumos values (null,"202001","02630","00091",30,20);
insert into consumos values (null,"202001","02630","41696",80,40);
insert into consumos values (null,"202002","02630","00091",100,80);
insert into consumos values (null,"202002","02630","41696",200,100);

it is the query when i get the average it gives me the current stock of the year 202001 but i want to have the stock of the year 202002



select annomes,cod_establecimiento,cod_med,avg(consumo),stock_actual
 from consumos group by cod_establecimiento,cod_med;

On average, our cryptographic signals are 95% accurate to reach the target – Statistics published!

Visit – https://t.me/btctradingclub

8eh3z7c.png "data-src =" https://i.imgur.com/8eh3z7c.png "src =" https://topgoldforum.com/applications/core/interface/js/spacer.png "/><br />
	<img class=