countifs between times

  1. J

    CountIfs Time Stamps

    Hi all, Having trouble with a CountIfs function. I am trying to answer the question: At any given time (down to the second), how many people were in attendance at our online course? My spreadsheet looks like this: A B C D E F SessionStart SessionEnd Concurrent Viewers 7:00:00 PM...
  2. H

    Counting the Number of a certain job code working in each hour w/ 24hr

    I am trying to set up a workbook to count the number of each job class that is working at a certain time, I am using this formula: =COUNTIFS(Data!$AA:$AA,Daily!$A3,Data!$J:$J,Daily!$C3,Data!$S:$S,"<="&Daily!E$1,Data!$V:$V,">="&Daily!E$2) Data!$AA:$AA= jobcode Daily!$a3= Jobcode I want to count...
  3. T

    Formula to Count Data in a Range That is Consecutively Outside of a Specification

    Hello all, I am trying to create a single formula in a single cell that lists the number of times an out of specification condition occurs for greater than two hours. As an example: Time Temp 0:00 -15 0:15 -15 0:30 -16 0:45 -16 1:00 -17 1:15 -18 1:30 -20 1:45 -20 2:00...
    • templetonjp
    • Thread
    • countif countifs between times countifs; array frequency function less than
    • Replies: 10
    • Forum: Excel Questions
  4. E

    COUNTIF time interval falls between set of time ranges

    Hi Everyone, I have a list of classes with the day along with start & end times in one spreadsheet. The format looks like this: M 8:00 AM - 9:50 AM T 12:30 PM - 2:20 PM M 9:00 AM - 10:15 AM F 7:00 AM - 1:00 PM In another spreadsheet i have a table like this one below. I want to know how many...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top