## 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;

``````