+ Reply to Thread
Results 1 to 3 of 3

If statement to determine if time value is higher than another time value

  1. #1
    Registered User
    Join Date
    04-29-2013
    Location
    Connecticut
    MS-Off Ver
    Excel 2003
    Posts
    17

    If statement to determine if time value is higher than another time value

    I have a spreadsheet with a bunch of time values (formatted as [h]:mm). I'm trying to write an IF statement that will determine if a cell value is higher than 40:00. I can't seem to figure it out. Any suggestions?


    EDIT - If I type 40:00 in a random cell (we'll say B1) and the time I'm comparing is in A1 and have a formula like IF(A1>=B1,TRUE,FALSE). That works...but i was wondering if there is a way to put the 40:00 into the formula rather than typing it in a cell.
    Last edited by xtort81; 08-15-2013 at 03:37 PM.

  2. #2
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: If statement to determine if time value is higher than another time value

    =IF(a1>40/24,value if true, value if false)
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  3. #3
    Registered User
    Join Date
    04-29-2013
    Location
    Connecticut
    MS-Off Ver
    Excel 2003
    Posts
    17

    Re: If statement to determine if time value is higher than another time value

    Perfect!!! Thanks Ace!

+ 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. Replies: 21
    Last Post: 11-30-2012, 07:28 PM
  2. determine $Value by time periods
    By chrcors01 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-26-2012, 10:11 PM
  3. Replies: 6
    Last Post: 03-04-2011, 08:42 AM
  4. Speed Improvement - Macro extract higher/lower values and note time differences
    By ExcelQuestFL in forum Excel Programming / VBA / Macros
    Replies: 29
    Last Post: 07-10-2009, 08:50 AM
  5. Determine time of each cycle
    By kerkklok in forum Excel General
    Replies: 3
    Last Post: 02-26-2009, 10:04 AM

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