Results 1 to 2 of 2

Calculation of time: Negative number

Threaded View

  1. 06-22-2015, 02:35 PM #1
    doop4204
    doop4204 is offline
    Registered User
    Join Date
    01-13-2015
    Location
    WI
    MS-Off Ver
    Office 2013
    Posts
    46

    Calculation of time: Negative number

    See attached. Column AI will show me if the patient is roomed on time by subtracting Column H and D. If the patient is roomed early the data shows as ####. Can this show as a negative number? If not, any recommendations how to show this.

    This is also happening for column AK as well.

    Thanks for the help.

    Shawn
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Time calculation that will calculate the postive and negative values
    By WJC1981 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-03-2014, 03:52 PM
  2. Positive/Negative Number Calculation
    By AlmostAGeek in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-12-2007, 10:26 AM
  3. [SOLVED] Negative Time Calculation
    By John in forum Excel General
    Replies: 3
    Last Post: 04-21-2005, 12:06 PM
  4. How do you enter a negative time number in Excel?
    By Thomas99 in forum Excel General
    Replies: 5
    Last Post: 03-17-2005, 08:06 PM
  5. [SOLVED] 2003= negative number&2004= negative number How Do I Calculate gro
    By Jason in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-14-2005, 02: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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1