How to convert minutes into sec

Turtle

New member
Joined
Aug 19, 2014
Messages
29
Reaction score
0
Points
0
Hi,

I need to convert minutes (L6-L18) to seconds in T6-T18. But how to I do this if there is a cell that is already in seconds? So lets say L7 is already entered as seconds:)35)...what formula would I use, in T7 to know that L7 is already in seconds and it doesnt need to convert it..just have it enter it as 35?
 

NBVC

Super Moderator
Staff member
Joined
May 20, 2011
Messages
1,518
Reaction score
0
Points
0
Location
Mississauga, Canada
Excel Version(s)
Excel 2016
Can you give more examples of what is in L6:L18 (i.e if there are mixed min/sec too) and the actual results you want to see. Also are you entering that as colon and 35 or are you formatting to show that way?
 

Turtle

New member
Joined
Aug 19, 2014
Messages
29
Reaction score
0
Points
0
Well, Hello! :)

Yes, for L6-L18 currently I have the following:

:35
2:14
:22
:37
:09
:20
1:47
1:03
:48
2:08
:21
:29
:53

So then for L6 entered at :35 I need the for T6 to read it as 35
and for L7 entered as 2:14 to have T7 be 134 Does this make sense?
 

NBVC

Super Moderator
Staff member
Joined
May 20, 2011
Messages
1,518
Reaction score
0
Points
0
Location
Mississauga, Canada
Excel Version(s)
Excel 2016
Does this work?

=IF(LEFT(L6)=":",--MID(L6,2,255),L6*60*24)

or

=IF(ISNUMBER(L6),L6*60*24,--MID(L6,2,255))

copied down
 

Turtle

New member
Joined
Aug 19, 2014
Messages
29
Reaction score
0
Points
0
The first one worked great! (=IF(LEFT(L6)=":",--MID(L6,2,255),L6*60*24))

Thanks again NBVC!! :)
 
Top