Results 1 to 6 of 6

Thread: How to convert minutes into sec

  1. #1

    Question How to convert minutes into sec



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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?

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,429
    Articles
    0
    Excel Version
    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?


  3. #3
    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?

  4. #4
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,429
    Articles
    0
    Excel Version
    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


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

    Thanks again NBVC!!

  6. #6
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,429
    Articles
    0
    Excel Version
    Excel 2016
    No Problem


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •