Results 1 to 4 of 4
  1. #1
    3 Star Lounger baumgrenze's Avatar
    Join Date
    Feb 2001
    Location
    California, USA
    Posts
    262
    Thanks
    6
    Thanked 0 Times in 0 Posts

    Hrs:Min Excel 2000 (2000 (9.0.6926 SP-3))

    Forgive a Luddite for still using Win98 SE-2 and Excel 2000. I understand that for a 2007 new system, not only do I need a new computer, but all new peripherals (printer, scanner, photo scanner...) and software, to be compatible with Vista! That's quite a budget item, if not in the Gate's household, at least in mine.

    I just tried "Format>Time" and also "Format>Custom" and discover that all of the formats revert to "month/day/year hours:minutes:seconds AM/PM" regardless of the format I chose. Is this just considered a 'feature' of Excel 2000 that was 'improved' in subsequent versions, to which I should upgrade to allow formatting of cells?

    The software suggests that I should be able to enter "10" and have it interpreted as 10:00, no?

    Thanks,
    Baumgrenze
    Hier sind wir tief eingewurzelt.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Hrs:Min Excel 2000 (2000 (9.0.6926 SP-3))

    You don't have to upgrade, but you do have to enter 10:00 - if you enter 10 in a cell formatted with a time format, it is interpreted as Midnight on January 10, 1900. This has been the case in all versions of Excel, as far as I know. You can be lax and enter 10:0 or even 10: but you cannot omit the colon.

  3. #3
    3 Star Lounger baumgrenze's Avatar
    Join Date
    Feb 2001
    Location
    California, USA
    Posts
    262
    Thanks
    6
    Thanked 0 Times in 0 Posts

    Re: Hrs:Min Excel 2000 (2000 (9.0.6926 SP-3))

    Thanks, Hans.

    Perhaps you will agree with me that this in 'inconsistent behavior' given that entering a "10" in a cell formatted as "currency" or "accounting" 'automatically' enter the $ sign and the number of decimal places you specify.

    Why is it that we pay such high prices for Microsoft software?

    thanks
    Baumgrenze
    Hier sind wir tief eingewurzelt.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Hrs:Min Excel 2000 (2000 (9.0.6926 SP-3))

    There is a difference: in a cell formatted as currency that displays $12.00, the stored value is 12, but in a cell formatted as time that displays 12:00, the stored value is *not* 12, but 0.5, since time values are stored as fractions of a day: 12 hours = 12/24 day = 0.5.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •