+ Reply to Thread
Results 1 to 5 of 5

text convert to time format

  1. 06-10-2014, 01:29 PM #1
    makinmomb
    makinmomb is offline
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,611

    text convert to time format

    How do i convert these texts into time formatted

    08:53:49
    08:53:49
    08:53:49
    08:53:50
    08:53:50
    Last edited by makinmomb; 06-10-2014 at 01:31 PM. Reason: unwanted for next string
    Reply With QuoteRegister To Reply
  2. 06-10-2014, 01:31 PM #2
    makinmomb
    makinmomb is offline
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,611

    Re: text convert to time format

    for sumifs arthimatics
    Last edited by makinmomb; 06-10-2014 at 01:32 PM. Reason: macro line not required
    Reply With QuoteRegister To Reply
  3. 06-10-2014, 01:34 PM #3
    makinmomb
    makinmomb is offline
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,611

    Re: text convert to time format

    should it be format cells or there is a formula ?
    Reply With QuoteRegister To Reply
  4. 06-10-2014, 01:44 PM #4
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,380

    Re: text convert to time format

    Those values listed already look like times. So, assuming they only "look like times" but are text strings, use:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.



    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  5. 06-10-2014, 02:18 PM #5
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: text convert to time format

    Or data > text to columns, finish.
    Entia non sunt multiplicanda sine necessitate
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Convert date and time in serial number format to text format
    By nda13112 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-11-2013, 02:45 PM
  2. How to convert time format from text?
    By redryder in forum Excel General
    Replies: 5
    Last Post: 04-30-2010, 04:36 AM
  3. Convert text to time format
    By maverick_abhi in forum Excel General
    Replies: 2
    Last Post: 07-27-2006, 07:20 AM
  4. [SOLVED] How do I convert a time to text format.
    By Rick in forum Excel General
    Replies: 4
    Last Post: 02-20-2006, 07:10 PM
  5. [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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1