Count if specific time falls within time range

**JPED41** · 07-09-2018, 07:08 PM

Hi All.

I have a list of classes that range from 30 minutes to 3 hours. I want to know at a given point in time how many classes are going on.

Excel help.PNG

Thank you in advance for the help!

**Phuocam** · 07-09-2018, 07:31 PM

Like this:

=COUNTIFS(EndClass,">=9:00",StartClass,"<=9:30")

Count if specific time falls within time range

LinkBack

Thread Tools

Rate This Thread

Display

Count if specific time falls within time range

Re: Count if specific time falls within time range

Thread Information

Users Browsing this Thread

Similar Threads

Check if range of time falls in another range of time and get difference

[SOLVED] Check if range of time falls in another range of time

determine if a certain time stamp falls into a certrain time range

[SOLVED] How to see if a specific date and time falls between two date/time fields

Average values if the associated time of occurence falls within a certain time range

Excel 2007 : Checking if a time cell falls within a given time range

Detecting whether a time falls within a military time range

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions