Converting minutes to seconds

S

smith.james0

How do i convert minutes to seconds?

4 Minutes 11 seconds = 251 seconds

How do i get excel to do it for me? :confused:


Thanks Jame
 
G

Glen Mettler

How is the data presented?
If it always comes as 4 Minutes 11 seconds then you could do this:
(supposing A1 contains "4 Minutes 11 seconds ")
then in B1 = mid(a1,1,2)*60 + mid(a1,11,2)
this will produce 251

Glen
 
E

Earl Kiosterud

James,

If it's a bona fide time value in the cell (entered as 0:4:11), you can do
it with cell formatting:

Format - Cells - Number - Custom:
[ss]
[ss.00]

Note that it must have been entered as 0:4:11, not as 4:11, the latter being
interpreted by Excel as 4 hours 11 minutes.

Or you can use a formula to yield an ordinary number, representing seconds,
with:

= A2 * 24 * 60 * 60

Format as number (not date/time)
 
A

Aladin Akyurek

Supposing that A1 houses a true time value like 0:04:11, try:

=A1*86400

Format the formula cell as General.
 
S

Saray

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!
 
C

cincode5

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.
 
G

Gary''s Student

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
 
D

Dave Peterson

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.
 
S

Saray

Hi all,

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

Anyway, your help is much appreciated!

:) :) :rolleyes: :) :rolleyes
 
Top