Re: fixing time column

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Tracey (wpiis_at_gte.net)
Date: 09/28/04

  • Next message: greg: "conditional formatting" 
    Date: Tue, 28 Sep 2004 16:06:08 -0400

    When I apply the format 00:00 to both column, only 1 reformats, the 2nd
    column the single digit hours stay single digit when they should be padded
    with a zero.

    First column has 7:58 which converts to 07:58
    Second column 8:03 does NOT convert to 08:03, but just displays 8:03
    Sample:
    13:36 7:47
    16:12 8:03
    07:58 17:32
    07:58 17:43
    12:31 17:31
    12:32 8:00
    12:32 8:03
    12:33 8:00
    12:34 7:56

    When I move the cursor over the cell with "8:03" the cell in the formula bar
    displays 8:03:00 AM so I know it recognizes the time.
    I even copied and pasted the "8:03:00 AM" from the cell in the formula bar
    into this email.

    Just as an example, I want to format times with single digit hours (like
    8:03) like 08:03 double digit with a leading zero.

    Tracey
    "Dave Peterson" <ec35720@msn.com> wrote in message
    news:4159BEB6.106C2D80@msn.com...
    > The first thing I'd try is to select that column and then
    > Edit|replace
    > what: : (colon)
    > with: : (colon)
    >
    > to see if excel would convert it to time.
    >
    > If it did, then I'd format it the way I wanted.
    > format|cells|number tab|custom
    > hh:mm
    > (maybe)
    >
    > If that didn't work, how about some examples of the problem values?
    >
    > Tracey wrote:
    > >
    > > some are 1 digit colon 2 digits and some are 2 digits colon 2 digits
    > > I recognize them all as a time of day.
    > > All I wanted to do is make them all look like 2 digits colon 2 digits
    even
    > > if the hour is before 10 o'clock.
    > > Tracey
    > >
    > > "Dave Peterson" <ec35720@msn.com> wrote in message
    > > news:4158774F.10282715@msn.com...
    > > > What do the values in that second column look like?
    > > >
    > > > Maybe excel can't recognize them as times.
    > > >
    > > > Tracey wrote:
    > > > >
    > > > > How can I extract/copy the time from 1 column to another and
    > > successfully
    > > > > apply a time format of 00:00 to the new column/data?
    > > > >
    > > > > I imported tab delimited data which contains 2 columns with time
    values.
    > > > > The first time column successfully receives the time format 00:00 (I
    do
    > > this
    > > > > so they are a uniform width).
    > > > > However the 2nd time column does not receive the time format not and
    I
    > > > > cannot "see" what is preventing the time format from being applied.
    > > > >
    > > > > Any help will be appreciated.
    > > > > Thanks, Tracey
    > > >
    > > > --
    > > >
    > > > Dave Peterson
    > > > ec35720@msn.com
    >
    > --
    >
    > Dave Peterson
    > ec35720@msn.com

  • Next message: greg: "conditional formatting"

    Relevant Pages

    • Re: fixing time column
      ... other characters in that cell--non-breaking spaces. ... If you format the cell as General, does it change to a decimal smaller than ... > column the single digit hours stay single digit when they should be padded ...
      (microsoft.public.excel)
    • Re: Time entered (and handled as data) in simple minutes and seconds.
      ... Then do all your data entry and then use that formula to convert to ... Put 60 in an empty cell ... And format the way you want. ... single digit minutes ...
      (microsoft.public.excel)
    • Re: Time entered (and handled as data) in simple minutes and seconds.
      ... Maybe you could use a helper cell: ... Then do all your data entry and then use that formula to convert to minutes. ... And format the way you want. ... single digit minutes and ...
      (microsoft.public.excel)
    • Re: Formatting output
      ... I am trying to do formatted output of single digit decimals. ... //and my attempt to format the output ... You write a string; the third parameter is optional and is the number of bytes to write. ... You need fprintf() instead. ...
      (alt.php)
    • Re: Requiring a date be entered as mm/dd/yy on a form field.
      ... completely validate a date entered in this format. ... cultures often have difficulty even comprehending internationalizaion ... can easily be done and will cause some input errors to be corrected: ... For a common case of a single digit being off by one, ...
      (microsoft.public.scripting.jscript)