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