+ Reply to Thread
Results 1 to 10 of 10

change time format to text

  1. #1
    Registered User
    Join Date
    09-05-2013
    Location
    Florida
    MS-Off Ver
    Excel 2010
    Posts
    71

    change time format to text

    hi ... i would LOVE it if someone could provide an easy way to accomplish the following, turn a list like this:

    582762 790507 2:36
    582755 790511 2:37
    582744 790515 2:38
    582750 790528 2:39
    582730 790531 2:40
    582735 790543 2:41
    582715 790545 2:42
    582722 790563 2:43
    582707 790565 2:44
    582706 790570 2:45
    582692 790588 2:46


    into a list like this:

    582762 790507 236
    582755 790511 237
    582744 790515 238
    582750 790528 239
    582730 790531 240
    582735 790543 241
    582715 790545 242
    582722 790563 243
    582707 790565 244
    582706 790570 245
    582692 790588 246

    where the time is essentially text or a number now

    THANKS!

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2502 Win 11
    Posts
    24,580

    Re: change time format to text

    Are these in three separate columns or is the data all in one column?
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    09-05-2013
    Location
    Florida
    MS-Off Ver
    Excel 2010
    Posts
    71

    Re: change time format to text

    its in 3 columns

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,044

    Re: change time format to text

    Are they hours and ninutes or minutes and seconds?

    It might be easier to work something out for you if you provided a small sample - when you copy/paste here sometimes it doesnt come through how you meant it to
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  5. #5
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: change time format to text

    In a separate column

    =TEXT(C2,"hhmm")
    or
    =TEXT(C2,"hmm")
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  6. #6
    Registered User
    Join Date
    09-05-2013
    Location
    Florida
    MS-Off Ver
    Excel 2010
    Posts
    71

    Re: change time format to text

    new to uploading files, did this work?
    Attached Files Attached Files

  7. #7
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: change time format to text

    Highlight the column and go to format cell and select Custom. Type in hmm. No formula!
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

  8. #8
    Registered User
    Join Date
    09-05-2013
    Location
    Florida
    MS-Off Ver
    Excel 2010
    Posts
    71

    Re: change time format to text

    YES!!! thanks!

  9. #9
    Registered User
    Join Date
    09-05-2013
    Location
    Florida
    MS-Off Ver
    Excel 2010
    Posts
    71

    Re: change time format to text

    am i supposed to say "solved" somewhere on your post in this forum?

  10. #10
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: change time format to text

    You're welcome. Don't forget to thank those who helped by clicking on Add Reputation * and please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools-> Mark thread as Solved).

+ 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. Change format of lots of data cell to a time format
    By dazza67 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 03-24-2013, 03:24 PM
  2. 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
  3. VBA automatically change text format into general format?
    By Nicawette in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-13-2006, 08:40 AM
  4. [SOLVED] Change number (in text format) to numeric format
    By Pam in forum Excel General
    Replies: 5
    Last Post: 10-24-2005, 03:05 PM
  5. Format Number to Text:How can I change the format in sheet1
    By Roni in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-17-2005, 11:06 AM

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