Results 1 to 7 of 7

Help to modify conditional formatting formulas that display on time and late based on time

Threaded View

  1. #1
    Forum Contributor
    Join Date
    03-15-2023
    Location
    Seattle, USA
    MS-Off Ver
    Office 365 subscription V2305
    Posts
    138

    Help to modify conditional formatting formulas that display on time and late based on time

    Hello

    I am using the following formulas to conditionally format my worksheet.

    Red: (Late)
    Formula: copy to clipboard
    =IF(OR($A2="",$B2="",$C2=""),"",MOD($C2,1)>MOD($A2,1))


    Green: (On time)
    Formula: copy to clipboard
    =IF(OR($A2="",$C2=""),"",MOD($C2,1)<=MOD($A2,1))


    The problem I noticed is when the scheduled time/date to be completed is the next day. If a task is completed (see row 5 for example) on July 1st @ 23:40 and is not scheduled to depart until July 2nd @1:30am it formats it red (late) and I would like it to be green. Is there a way to modify the formula so this does not happen? Please see attached worksheet.

    Thank you
    Attached Files Attached Files
    Last edited by Longbow 44; 07-10-2023 at 10:41 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Help with code to display "On time" or "Late" depending on time entered by user
    By Longbow 44 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-28-2023, 10:17 PM
  2. Conditional formatting based on time due
    By maeayanami in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 09-13-2017, 03:03 PM
  3. Conditional Formatting - time based
    By rosethorn5 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-01-2017, 03:00 PM
  4. Formula to Display Notification LATE, EARLY, ON TIME
    By Daryl10 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-12-2014, 06:27 PM
  5. [SOLVED] IF function: Early/On Time/Late Time vs. set window of time
    By hclark579 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-21-2014, 05:37 PM
  6. Replies: 6
    Last Post: 02-06-2012, 12:25 PM
  7. Conditional formatting based on time
    By sharkey in forum Excel General
    Replies: 2
    Last Post: 12-24-2007, 02:13 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