I used the formula:
= ArrayFormula(SUM(min(A2:A1294)*(U2:U1294="")))
The A column contains timestamps, and I got the result "46809654.36".
I want to convert this to a format like "2020. 5. 1 pm 5:27:01", but it won't change. How can I fix this?
Use filter(), like this:
filter()
=min(filter(A2:A1294, U2:U1294 = ""))
See filter().