Results 1 to 4 of 4

IF statement involving time subtraction versus entered time data

Threaded View

  1. 02-08-2016, 11:04 AM #1
    JasonTran
    JasonTran is offline
    Registered User
    Join Date
    02-05-2016
    Location
    Toronto, Canada
    MS-Off Ver
    Microsoft Office 2013
    Posts
    2

    IF statement involving time subtraction versus entered time data

    Hi,

    I'm trying to use an IF statement to determine if entered time versus calculated time via subtraction are equal to one another. I seem to be having a problem as for some time values the IF statement is working correctly, however for other values it is not. Does anyone know why this would be? I have attached photos with the designated cells. Cell P51 is 12:12:00 AM; similar to P114.

    Thanks
    Attached Images Attached Images
    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. [SOLVED] IF statement on data validation, End time greater than Start time
    By Faridwahidi in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-02-2014, 08:04 AM
  2. Repeating a date/time subtraction that meets certain conditions involving multiple rows?
    By rgoodman in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-17-2013, 02:13 PM
  3. If statement involving time (RESOLVED)
    By o4008 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-27-2013, 11:27 AM
  4. Issue with IF statement involving time variables
    By persistent. in forum Excel General
    Replies: 1
    Last Post: 07-03-2012, 10:56 PM
  5. Excel 2007 : Time Stamp: Every time data is entered
    By otanii in forum Excel General
    Replies: 1
    Last Post: 08-04-2011, 05:29 PM
  6. Prompt message of time limit when time is entered
    By minato in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-31-2008, 10:13 AM
  7. Show timesheet time in and out in regular time versus military tim
    By John in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-11-2005, 01:20 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1