Share via

Need to Calculate How Many People Are Working At The Same Time

Anonymous
2020-07-02T07:57:54+00:00

I am trying to calculate how many people are working at the same time. I used the following formula which I got it from the web, but it did not work for me. The result I got is 0!!!

I format all cells that contain time with h:mm AM/PM format. The "Staff Working" column format as General

I appreciate it if you could look at it, and see if you can direct me.

Thank You

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. HansV 462.6K Reputation points MVP Volunteer Moderator
    2020-07-04T18:43:06+00:00

    Change the formula to

    =COUNTIFS($C$3:$C$12, "<" &F3, $D$3:$D$12, ">=" &F2)

    2 people found this answer helpful.
    0 comments

Answer accepted by question author

  1. HansV 462.6K Reputation points MVP Volunteer Moderator
    2020-07-02T12:33:11+00:00

    In your screenshot, there is no username working at 7:00 PM: Ali starts at 9:51 PM and Nadeem at 7:08 PM. That is after 7:00 PM.

    0 comments

6 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Andreas Killer 144.1K Reputation points Volunteer Moderator
    2020-07-02T08:38:29+00:00

    Take a look at this file, it calculates how many ships have moored at the same time:

    https://www.dropbox.com/s/1oy9ege6ytosvt4/fa36c5e6-5afa-418e-8ebe-45065f705f53.xlsx?dl=1

    Thread is here, please use Google Translator to translate it from German to your locate language.

    https://answers.microsoft.com/de-de/msoffice/forum/all/excel-berechnunggleichzeitige-schiffsanlegungen/fa36c5e6-5afa-418e-8ebe-45065f705f53

    Andreas.

    0 comments
  2. Anonymous
    2020-07-02T08:26:47+00:00

    Hi Khalid,

    The formula you input should be correct. As I can use the same formula on my side without issue:

    The only difference I see is the quote mark. Mind if replacing your quote mark with " to check the result?

    Also, you need to make sure there is no number stored as text in your data table. If you could share your workbook with us, it will be a great help for us to identify the issue.

    Regards,

    Alex Chen

    0 comments
  3. HansV 462.6K Reputation points MVP Volunteer Moderator
    2020-07-02T08:23:43+00:00

    Replace the curly quotes ” around >= and <= with straight quotes "

    0 comments