If you want still want to get time value from time that is not formated as text, use below TIMEVALUE formula. =TIMEVALUE(TEXT(A4,"HH:MM:SS")). 0029. Here, we ...
確定! 回上一頁