Results 1 to 9 of 9

Time displayed in weird way

Threaded View

  1. #1
    Registered User
    Join Date
    04-25-2008
    Location
    Essex, England
    MS-Off Ver
    Office 2010
    Posts
    52

    Time displayed in weird way

    Hi,

    I have attached a sample sheet as easier to see.

    Basically the result in n3 displays as 0:00 and the result in n4 as -0:00. Same for o3 and o4.

    I have been over and over and over it but can't find any reason at all it should do this?

    I want 0:00 to display as 0:00 and anything minus as -0:00

    Have set up as [h]:mm;[Red]-[h]:mm and also tried with a 0 on etc. Just not having it.

    Any help appreciated. Cheers!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Getting rid of weird time format 01m 16s
    By rooonik in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-29-2013, 11:08 AM
  2. [SOLVED] Time measures in weird format
    By andrewmo in forum Excel General
    Replies: 10
    Last Post: 09-21-2012, 03:41 PM
  3. Time displayed in a singel cell
    By Notters in forum Excel General
    Replies: 6
    Last Post: 12-14-2009, 03:39 PM
  4. Time question-displayed as a fraction
    By hexOffender in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-02-2007, 04:32 PM
  5. Weird... type mismatch only half of the time
    By paulharvey in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-16-2005, 01:05 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