+ Reply to Thread
Results 1 to 4 of 4

I'm trying to show if an employee was working during a particular hour within a date range

  1. #1
    Registered User
    Join Date
    11-19-2014
    Location
    Jacksonville, FL
    MS-Off Ver
    2013
    Posts
    2

    I'm trying to show if an employee was working during a particular hour within a date range

    So I have a list of employees with their start date/ time and their stop date/ time. I'm trying to identify if they were were working during a particular hour of day. Most of the IF(AND) formulas work as long as they clock in and out on the same day. On the attachment it shows some sample data and what I would expect it to populate with. My end goal is to be able to show which hours of the day an employee was working. ANY help would be greatly appreciated.
    Attached Files Attached Files

  2. #2
    Cheeky Forum Moderator Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: I'm trying to show if an employee was working during a particular hour within a date r

    I'm not a date/time formula expert...but
    Using your posted workbook, this regular formula, copied across and down, returns the values you're looking for
    Please Login or Register  to view this content.
    Is that something you can work with?
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

  3. #3
    Registered User
    Join Date
    11-19-2014
    Location
    Jacksonville, FL
    MS-Off Ver
    2013
    Posts
    2

    Re: I'm trying to show if an employee was working during a particular hour within a date r

    Ron,

    This is fantastic! First I want to thank you for the quick response! I applied the formulas to my master template and it works great! I'm embarrassed to tell you how much time I spent attempting this yesterday on my own.

    Again, many many thanks for your assistance!

    Best regards,
    Mark

  4. #4
    Cheeky Forum Moderator Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: I'm trying to show if an employee was working during a particular hour within a date r

    Glad you got something you can use!

    If that resolves your issue, please take a moment to mark this thread as SOLVED (from the Thread Tools menu)

+ 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. [SOLVED] Formula to convert 24 hour day to 8 hour (working) day?
    By miro2021 in forum Excel General
    Replies: 4
    Last Post: 07-31-2017, 10:06 AM
  2. Best Chart to show employee's average working time!
    By devpp in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-27-2013, 04:21 AM
  3. How do I? Hour by Hour Occurrences between a Date Range?
    By lesoies in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-06-2013, 09:01 PM
  4. [SOLVED] Formula to calculate if employee is working on each half hour
    By holowugz in forum Excel General
    Replies: 10
    Last Post: 07-16-2012, 08:29 PM
  5. Find and calculate employee hours within date range
    By rockytop80 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-14-2011, 11:43 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