Results 1 to 7 of 7

Help with times

Threaded View

  1. #1
    Registered User
    Join Date
    09-28-2018
    Location
    El Salvador
    MS-Off Ver
    365
    Posts
    21

    Post Help with times

    Hello Guys, currently I am working on an excel sheet that my boss has asked me to do. The excel table has cells in time format; for example, 00:00:00 for 12 am, and 00:05:00 for 12:05 am. My boss would like the table to highlight the cell that contains 00:00:00 if the current time is between 12:00:00 a.m. and 12:04:59 a.m. And highlight 00:05:00 if the cell is between 12:05:00 a.m. and 12:09:59 a.m.

    I understand that somehow this is doable with custom formatting (correct me if I'm mistaken please) However, I have not found the way to make this work. Can you please help me on this? I only know about excel when it comes to finance.

    Thanks in advance.
    Last edited by kvallecillo; 09-28-2018 at 10:34 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Averaging the earliest start times and latest end times for multiple days
    By kbiro in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-26-2016, 02:15 PM
  2. Replies: 21
    Last Post: 05-11-2015, 03:53 PM
  3. If a search term can be found 1 time, 2 times 3 times 4 times 5 times
    By excelcandy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-10-2013, 09:57 PM
  4. [SOLVED] calculate turn around times range of times for weekday and weekend
    By xrayexceller in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 07-28-2013, 02:22 PM
  5. Macro Loop – Find Specific Times, Extract Date, Average Values of Times
    By ExcelQuestFL in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 02-25-2010, 02:50 PM
  6. Macro to help sort date - times and average similar times.
    By ferretydeath in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-26-2008, 05:44 PM
  7. [SOLVED] capture:How are relay leg times or driving times entered and totaled?
    By Bob Phillips in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 04:05 AM

Tags for this Thread

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