How to convert minutes into sec

[Turtle]

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 seconds35)...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]

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]

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]

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]

The first one worked great! (=IF(LEFT(L6)=":",--MID(L6,2,255),L6*60*24))

Thanks again NBVC!!

 

[NBVC]

No Problem