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
I have this error:
#VALUE! ERROR TIMEVALUE parameter '' cannot be parsed to date/time
How to exclude the cell with no value inside?