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

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

If you enter 4:11 (as minute:second) in cell A1, then enter
=SECOND(A1)+60*MINUTE(A1)
Format the other cell as General and you will get 251
--
Gary''s Student


"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

The thread aged off for me, but if I enter:
00:04:11
in A1, I can use this in B1:
=A1*60*60*24
(formatted as general)
and get 251 back.




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

--

Dave Peterson

Hi all,

Wow, I can't believe I would get so much replies in only one day. I've
tried all the solutions you suggested and they all worked! Now, I have
too many options...

Anyway, your help is much appreciated!

:) :) :)


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