+ Reply to Thread
Results 1 to 2 of 2

Output Time As Displayed In Cell

  1. #1
    Forum Contributor
    Join Date
    06-18-2007
    Location
    Kiama, Australia
    MS-Off Ver
    365
    Posts
    119

    Question Output Time As Displayed In Cell

    Hi Folks,

    I think this may be an easy one for the helpful members on this site.

    I'm trying to read time (mm:ss.00) from a cell and output to a text file as it is displayed.
    For example if my time is 2:43.15 I need to output "2:43.15" to the text file.
    I've tried using Format(ActiveCell.Value, "hh:mm:ss.00") but it does not include the hundredths ("00") component of the time.

    How can I format my output as mm:ss.00?
    Select "Add Reputation" to thank me.

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Output Time As Displayed In Cell

    This would output as it is displayed in the cell.
    ActiveCell.Text
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

+ 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. Replies: 0
    Last Post: 08-05-2015, 12:16 PM
  2. Need to edit how text output is displayed.
    By DoritoKing in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-14-2014, 10:18 AM
  3. Replies: 1
    Last Post: 08-21-2013, 04:20 PM
  4. [SOLVED] Set number value displayed in cell when certain text value is displayed in another
    By chrisswann in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-18-2013, 09:07 AM
  5. macro to compare time between two cells if time matches output in third cell
    By kshitij_dch in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-31-2012, 07:09 AM
  6. Time displayed in a singel cell
    By Notters in forum Excel General
    Replies: 6
    Last Post: 12-14-2009, 03:39 PM
  7. Windows Login and date/time displayed in a cell
    By nuno in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 08-15-2007, 04:15 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