LinkBack URL
About LinkBacks
It works for me with a small tweak (had to change s to s. and min to min.)
Put this formula in C2
=SUBSTITUTE(SUBSTITUTE(A2,"s.",""),"min.","")/IF(COUNTIF(A2,"*min*"),1440,86400)
format as mm:ss and then copy to D2 and down both columns
It works for me with a small tweak (had to change s to s. and min to min.)
Put this formula in C2
=SUBSTITUTE(SUBSTITUTE(A2,"s.",""),"min.","")/IF(COUNTIF(A2,"*min*"),1440,86400)
format as mm:ss and then copy to D2 and down both columns
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks