+ Reply to Thread
Results 1 to 5 of 5

Calculate number of employees working each hour.

  1. #1
    Registered User
    Join Date
    05-12-2019
    Location
    San Diego, California
    MS-Off Ver
    2007
    Posts
    2

    Calculate number of employees working each hour.

    Hi all! I am having difficulty using formulas to calculate the number of employees who are working each hour. I believe this is because my overnight shift is a little tricky. Below is the formula I am currently using and a snip of my scheduleSchedule photo.PNG Any ideas on how to get the overnight to calculate correctly, on the correct day would be greatly appreciated!

    =(COUNTIF($C$6:$C$23,">="&A35)-COUNTIF($B$6:$B$23,">"&A35))


    Thanks!

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    27,786

    Re: Calculate number of employees working each hour.

    Hi and welcome to the forum

    Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context. Pictures are rarely much use.

    Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.

    To upload a file click the Go Advanced button at the foot of your post, look underneath the post area for the Manage Attachments section and take it from there.
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    05-12-2019
    Location
    San Diego, California
    MS-Off Ver
    2007
    Posts
    2

    Re: Calculate number of employees working each hour.

    hi! Here is the workbook. :0
    Attached Files Attached Files

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    11,816

    Re: Calculate number of employees working each hour.

    See if the following will work for you:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    I have marked the schedules that showed differences between the formula and manual count (6:00 AM - 10:00 AM).
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  5. #5
    Registered User
    Join Date
    08-28-2020
    Location
    USA
    MS-Off Ver
    365
    Posts
    3

    Re: Calculate number of employees working each hour.

    Thanks JeteMc, this was a huge help!

+ 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. Calculate Number of Employees Who Were At Work Each Hour?
    By cr2crf in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-13-2017, 10:42 AM
  2. [SOLVED] COUNTIFS for # of Employees Working Each Hour from 11:00 PM to 4:00 AM
    By glynigin in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 12-14-2016, 07:41 PM
  3. [SOLVED] Count the number of employees working per hour
    By esmith#001 in forum Excel Formulas & Functions
    Replies: 27
    Last Post: 12-04-2014, 07:46 AM
  4. Calculate employees working from hour to hour
    By otter in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-03-2014, 08:57 AM
  5. Calculate # of employees each hour; sumif formulas
    By sprdsheet in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-05-2014, 12:29 PM
  6. Using Countif to determine number of employees working per hour
    By CBanks888 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-23-2013, 04:15 PM
  7. [SOLVED] calculate time for employees in 24 hour operation
    By HoweRich in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-17-2006, 03:33 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