I have a serie of time duration which are a result of a formula in a column formatted as Duration as well
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 Value. For the Average I tried this formula
=ARRAYFORMULA(AVERAGE(TIMEVALUE(E2:E305)))
I've got this error :
#VALUE! ERROR TIMEVALUE parameter '' cannot be parsed to date/time
How exclude the cell without any values inside ?