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
I've got this error :
#VALUE! ERROR TIMEVALUE parameter '' cannot be parsed to date/time
How exclude the cell without any values inside ?