+ Reply to Thread
Results 1 to 6 of 6

Converting standard text to hh:mm:ss

  1. #1
    Registered User
    Join Date
    10-01-2012
    Location
    molde
    MS-Off Ver
    Excel 2010
    Posts
    49

    Converting standard text to hh:mm:ss

    Hi
    Does enyone know how I can convert standard text 160:00 to time 160:00:00? The output format of reports I'm getting from an other program makes it difficult to work with the numbers in excel.

  2. #2
    Registered User
    Join Date
    09-21-2012
    Location
    Mumbai, India
    MS-Off Ver
    Excel 2003
    Posts
    93

    Re: Converting standard text to hh:mm:ss

    format cell as custom [h]:mm:ss

  3. #3
    Forum Contributor LokeshKumar's Avatar
    Join Date
    03-31-2015
    Location
    India
    MS-Off Ver
    All, mostly 2010 now..
    Posts
    471

    Re: Converting standard text to hh:mm:ss

    Hi,
    Try to use
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    If your question is resolved, mark it SOLVED using the thread tools. Click on the star if you think some-1 helped you.
    Lokesh Kumar
    Stay Hungry.. Stay Foolish..
    _________________________________________________________
    Please Click STAR to Add Reputation if my/someone's answer helped!

  4. #4
    Registered User
    Join Date
    10-01-2012
    Location
    molde
    MS-Off Ver
    Excel 2010
    Posts
    49

    Re: Converting standard text to hh:mm:ss

    I dit that, but it din't change to the format i wanted. Not unless I double click the cell and press enter. But then I'd have to do the same thing in every cell... A lot of work with a very big report.

  5. #5
    Registered User
    Join Date
    10-01-2012
    Location
    molde
    MS-Off Ver
    Excel 2010
    Posts
    49

    Re: Converting standard text to hh:mm:ss

    Thanx, but I need it to change format in the native cell.

  6. #6
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,914

    Re: Converting standard text to hh:mm:ss

    Will you upload sample file
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

+ 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. Error after converting standard workbook to add in
    By IainMcK12345 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-14-2014, 12:14 PM
  2. Replies: 4
    Last Post: 05-10-2014, 10:45 AM
  3. [SOLVED] Converting Standard Time format (hh:mm:ss) to number of minutes
    By xygrax in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-27-2014, 10:54 AM
  4. Converting all date formats to one single standard format.
    By booo in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-25-2010, 07:14 PM
  5. Converting name to standard time
    By sridharKj in forum Excel General
    Replies: 1
    Last Post: 03-21-2005, 12:38 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