Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: negative time formula

  1. #1
    New Member
    Join Date
    May 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    i am trying to get a negative time formula but cannot achieve it

    for example
    column a b c
    10:00 - 12:00 = -2:00(red )

    any help please would be appreciated

    [ This Message was edited by: 51lky on 2002-05-06 08:56 ]

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    84,026
    Post Thanks / Like
    Mentioned
    37 Post(s)
    Tagged
    7 Thread(s)

    Default

    Switch to the 1904 date system thru Tools|Options...

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    What was significant about January 2nd 1904 to make it an alternative date system ?

  4. #4
    MrExcel MVP
    Join Date
    Apr 2002
    Location
    Vancouver BC , Canada
    Posts
    6,259
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    It has to do with backward compatability with previous systems. The 1904 system was designed to be compliant with MAC systems.
    Dates before 1904 were not supported on MAC systems. I believe MAC wanted to avoid the fact that there is a missed leap year previous to 1904 i.e. 1900.

    [ This Message was edited by: Nimrod on 2002-05-05 13:57 ]

  5. #5
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    84,026
    Post Thanks / Like
    Mentioned
    37 Post(s)
    Tagged
    7 Thread(s)

    Default

    On 2002-05-05 13:57, Nimrod wrote:
    It has to do with backward compatability with previous systems. The 1904 system was designed to be compliant with MAC systems.
    Dates before 1904 were not supported on MAC systems. I believe MAC wanted to avoid the fact that there is a missed leap year previous to 1904 i.e. 1900.

    [ This Message was edited by: Nimrod on 2002-05-05 13:57 ]
    That's right. & Excel was written first for Mac and the programmers avoided that Lotus 1-2-3 date glitch.

  6. #6
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    thanks guys

    (I should have figured that out.... shame on me!)


Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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