Results 1 to 21 of 21

Conditional Formatting Add 8 hours

Threaded View

  1. #1
    Registered User
    Join Date
    07-08-2019
    Location
    Shawnee, Oklahoma
    MS-Off Ver
    Office 365 ProPlus
    Posts
    51

    Conditional Formatting Add 8 hours

    Hello world,
    I am attempting to use conditional formatting to shade cells depending on completion times. Here is my setup and as always thank you very much for any and all help.

    F2 = Start Time
    R2 = Completion Time

    Here's my formula for red.
    =$R2<($F2+8/24)

    Rules
    Less than 8 hours from start to complete green
    exact or 1 hour over yellow
    greater than 1 hour over red

    I believe the issue I am running into is, since all of the times are overnight, when the time rolls past midnight the formula automatically assumes that it is way over or under the set formulas. Is there a way to do this without adding new columns? I've attached my testing spreadsheet to here as well.
    Attached Files Attached Files
    Last edited by AliGW; 07-09-2019 at 03:05 AM. Reason: Title made search engine friendly.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Timesheet that calcs time in, time out, lunch used, reg hours, ot hours, double hours
    By noobface in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 08-21-2021, 03:45 AM
  2. Replies: 3
    Last Post: 07-24-2018, 03:24 AM
  3. Seperate simple hours, holiday hours and night hours
    By enitron in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-27-2014, 07:22 AM
  4. Replies: 3
    Last Post: 06-18-2014, 07:26 AM
  5. [SOLVED] Calculate hours with predefined Working Hours and Weekend Hours
    By garciapliz in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-05-2013, 11:17 AM
  6. Replies: 4
    Last Post: 02-12-2013, 07:01 AM
  7. Replies: 2
    Last Post: 02-11-2013, 02:26 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1