Results 1 to 7 of 7

I need a zero in my cell rather than xxx after my calculation

Threaded View

  1. #1
    Registered User
    Join Date
    09-21-2014
    Location
    Wokingham
    MS-Off Ver
    Office 365
    Posts
    19

    I need a zero in my cell rather than xxx after my calculation

    Hi,

    I am trying to create a formula. I have a value in a cell that I have created by subtracting one time (hours / minutes) from a set time. For example contracted hours 60:00 is the set time and used hours is taken away from this. The problem I have is that if the time I am taking away is more than the set time I get xxxx value. If the time I am taking away is less than the set time I get the value I want. I need to have zero displayed the formula displays xxxx.

    This sounds confusing and I probably have not explained it well but any help will be greatly appreciated. Thanks
    Last edited by stuj77; 10-07-2014 at 10:21 PM. Reason: Incorrect Title

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 11
    Last Post: 06-06-2014, 03:34 PM
  2. how to hide formula in formula box, view lookup result in formula box?
    By vengatvj in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-14-2013, 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