seek time and excel

RT excel seek time and

e2 = IF (ISNUMBER (FIND (“points”, b2 )),””,” 0:”) & SUBSTITUTE (SUBSTITUTE (b2,” points “,”:”),” seconds ” ,””)& IF (ISNUMBER (FIND (“s”, b2 )),””,” 00 “) drop-down.f2 = text (sumproduct (- e2:e27),” [h] sub-mm sec “)

and the same number of sum and pay attention to the cell formatting set to “date” inside the time format.

the time format set out in B, classified as time, type, too minute to minute.sum can sum formula such as demand and B2 to B30, then B31, enter = sum (B2:B30)

you insert a column B, (ie C out), in C2 enter = “00:” & B2 to under filled.and then copy the C column, select Paste Special — B2 — Check the right value.then find the replacement, the points with:and second replacement is empty.This can be summed up.Remove the C column.

you the key points of this problem is the time you enter, say, 1 minute 20 seconds, if you entered is:00:1:20, and then modify the format elements seconds format.or input time is:1 minute 20 seconds If the former, as long as the sum through SUM.of course, that the results may have to repair it because your unit is only minutes and seconds, if there is carry it? such as 100 minutes and 20 seconds, is entered up, or is it maintained? If the latter, you must first deal with your input