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 :

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


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

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 –

8eh3z7c.png "data-src =" "src =" "/><br />
	<img class=