+ Reply to Thread
Results 1 to 2 of 2

Time formula help

  1. #1
    Registered User
    Join Date
    03-17-2017
    Location
    USA
    MS-Off Ver
    2016
    Posts
    1

    Time formula help

    Hello,

    I need urgent help regarding formula for time, I'm still new with excel so I'm not sure which is the best one.
    If possible with condition formatting so it's not too complicated.

    Let say, the schedule time are these: 7:00 am, 8:00 am, 9:30 am

    If actual log in time match the schedule time then I want it to highlight.

    And if actual log in time is: 7:01 am, 7:59 am, 9:35 am - I also want to highlight all the actual time that didn't match the schedule time.

    How would I do that it base on the minutes not the hour?

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,039

    Re: Time formula help

    Hi, welcome to the forum

    What you need to understand about dates and times in excel is...

    a date is just a number representing the number of days passed since 1/1/900...and then formatted in a way that we recognize as a date. So, for instance, today (Sun Mar 2017) is actually 42813

    Time is actually a decimal part of 1 (day), so 06:00 AM is 0.25, 12 noon is 0.5 and 18:00 (or 6 PM) is 0.75
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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. Formula for Timesheet - Double Time, Time Half and normal Hours
    By Tracs13 in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 09-12-2017, 09:40 PM
  2. [SOLVED] time sheet help, format TIME and formula based on the actual time entered.
    By bh mng in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 12-06-2016, 01:10 PM
  3. Replies: 3
    Last Post: 12-19-2013, 06:49 AM
  4. Replies: 5
    Last Post: 04-18-2013, 11:31 AM
  5. Formula for Calculating Paid Time Off for fiscal anniversary date real time
    By 168rockwood in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-07-2012, 04:15 PM
  6. Replies: 2
    Last Post: 04-27-2011, 08:21 AM
  7. [SOLVED] template or formula for start time -finish time -total hours ple
    By cc in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 03-27-2006, 01:10 PM

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