Hi Saray,

If your just looking to convert the 4:11 format to all seconds in a
different cell try using this formula in the destination cell:

=60*MID(E7,1,SEARCH(":",E7,1)-1)+(MID(E7,SEARCH(":",E7,1)+1,2))

This will work for any size Minute:Second combination (4:11 or 100:27 for
example). You MUST make sure the 4:11 cell is formatted as Text, because if
left as general or time or whatever else it is set to the formula will result
in a #VALUE error.

--
Regards...


"Saray" wrote:


Hi all,

How can I convert the minutes (which is presented as 4:11) to seconds?

I have tried all the solutions posted on this thread but none of them
worked! Help!!

Thank you!


--
Saray
------------------------------------------------------------------------
Saray's Profile: http://www.excelforum.com/member.php...o&userid=27087
View this thread: http://www.excelforum.com/showthread...hreadid=276410