+ Reply to Thread
Results 1 to 4 of 4

convert time

  1. #1
    Registered User
    Join Date
    12-03-2018
    Location
    Miami Lakes
    MS-Off Ver
    Office 365
    Posts
    1

    convert time

    I have a need to convert 28min 25sec into 0:28:25
    Suggestions please.....
    Thanks

  2. #2
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    2016
    Posts
    5,891

    Re: convert time

    Hello and welcome to the forum.

    This works for the single sample that you have shared:

    =TIME(0,LEFT(A1,2),MID(A1,7,2))

    Format as needed.

  3. #3
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    2016
    Posts
    5,891

    Re: convert time

    If you could have single digit minutes or seconds (without a 0 placeholder), you can use this:

    =TIME(0,LEFT(A1,FIND("m",A1)-1),SUBSTITUTE(RIGHT(A1,5),"sec",""))

  4. #4
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    2016
    Posts
    5,891

    Re: convert time

    Just for the fun of it, here's another version that is slightly shorter than the one in post #3:

    =SUBSTITUTE("0:"&SUBSTITUTE(A1,"min ",":"),"sec","")+0

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. how can add date this formula convert military time to normal time
    By mazan2010 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-27-2017, 02:22 PM
  2. Convert Julian time and year to standard date and time
    By gozo in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 09-11-2014, 06:42 AM
  3. Hi, I have hourly time series data and i need to convert it to 15 min time slots
    By neerajsharma887 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-15-2014, 01:08 PM
  4. Need Help with an user form that convert GTM Time to Other selected Time Zone
    By odoualex in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-08-2014, 11:52 AM
  5. Replies: 22
    Last Post: 09-15-2013, 10:43 AM
  6. [SOLVED] convert time imported as text to time format for calculations
    By batfish in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-27-2005, 07:05 PM
  7. Replies: 0
    Last Post: 08-23-2005, 12:22 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1