Results 1 to 7 of 7

Greater than in if statements?

Threaded View

  1. #1
    Registered User
    Join Date
    08-28-2011
    Location
    Tennessee
    MS-Off Ver
    Excel 2003
    Posts
    14

    Greater than in if statements?

    It seems to want to reference a cell when I use ">"

    I basically want it to say
    =IF(calculate!K21=0, " ", if( calculate!K21>12:59:59, calculate!K21-12:00:00, calculate!K21))
    but it says there's an error

    That way I can have the cells always return 12 hour increments instead of military time and return nothing but a space if there's a zero value in the referenced cell.
    Last edited by IRMacGuyver; 09-13-2011 at 07:51 PM.

Thread Information

Users Browsing this Thread

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

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