+ Reply to Thread
Results 1 to 4 of 4

Quick question about how to Remove #VALUE! error

  1. #1
    Registered User
    Join Date
    06-27-2014
    Location
    Philippines
    MS-Off Ver
    MS Office 2011
    Posts
    8

    Quick question about how to Remove #VALUE! error

    pareshJ already solve my problem but if theres no value on a cell it giving me a #VALUE! error is there a way
    it will show "00:00:00" if theres a VALUE error

    heres the nice code by pareshj on my problem recently

    "=TEXT(MID(RIGHT(A2,8),1,5)-LEFT(A2,5),"HH:MM:SS")"

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: Quick question about how to Remove #VALUE! error

    Like this, maybe:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Forum Expert sweep's Avatar
    Join Date
    04-03-2007
    Location
    Great Sankey, Warrington, UK
    MS-Off Ver
    2003 / 2007 / 2010 / 2016 / 365
    Posts
    3,440

    Re: Quick question about how to Remove #VALUE! error

    Hi,

    Untested, but should work...

    =IFERROR(TEXT(MID(RIGHT(A2,8),1,5)-LEFT(A2,5),"HH:MM:SS"),TEXT(0,"HH:MM:SS"))
    Rule 1: Never merge cells
    Rule 2: See rule 1

    "Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".

  4. #4
    Registered User
    Join Date
    06-27-2014
    Location
    Philippines
    MS-Off Ver
    MS Office 2011
    Posts
    8

    Re: Quick question about how to Remove #VALUE! error

    THANKS guys!

    Why if i =SUM(Cells :cells) the value is 0?? not how many hours

+ 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] Quick beginner question-Why doesn't On Error Exit Function work?
    By mc84excel in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 05-09-2013, 06:23 AM
  2. [SOLVED] Quick question about automatic row deletion (should be very quick and easy!!)
    By poptart141 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 04-09-2013, 12:56 PM
  3. Quick Question QUick Answer
    By ccraig61 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-25-2006, 09:34 PM
  4. Quick question - quick answer about assigning shortcut keys
    By funkymonkUK in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-13-2005, 06:05 AM
  5. [SOLVED] Quick question on Error Trapping
    By Darrin Henshaw in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-09-2005, 04:06 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