datetimegoogle-sheetsformatting

I can't convert 46809654.36 into a date and time value in Google Sheets


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?


Solution

  • Use filter(), like this:

    =min(filter(A2:A1294, U2:U1294 = ""))
    

    See filter().