+ Reply to Thread
Results 1 to 2 of 2

error with time formatting for negative time

  1. #1
    Registered User
    Join Date
    12-27-2013
    Location
    Oklahoma City
    MS-Off Ver
    Excel 2003
    Posts
    49

    Unhappy error with time formatting for negative time

    I'm doing simple time values, using 00:00 time format. when I calculate time difference, a negative time comes up #####. I just want to format the cell to return 0 or 0:00 instead of the #####s

    I attempted =iferror(A2-A1,"0:00") but that doesn't work

    any help appreciated

    Dan
    Last edited by dan_fash; 03-03-2015 at 10:48 AM.

  2. #2
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: error with time formatting for negative time

    Try

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

+ 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. [SOLVED] Simple Calendar pop up macro --> error Run-time error '424': Object required
    By am_hawk in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-11-2013, 10:38 AM
  2. [SOLVED] Get Run-Time Error 1004 With Simple Macro
    By One-Eyed Enos in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-22-2012, 01:46 PM
  3. Insert new row creates Run-time error 13 with exisiting simple code
    By madball87 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-23-2011, 09:54 AM
  4. Run time error 1004 macro (Simple)
    By mcneill_garr in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-17-2011, 10:27 PM
  5. Run time error 1004-some pretty simple VBA.
    By garyi in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-12-2011, 02:11 PM

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