Excel Formula: Count Times in A Range
Author: Sun
Last Modified: 2020-12-04
The COUNTIFS function can count the number of times between two times in Excel.
If you want to follow along with this tutorial, please download the example spreadsheet.
Generic formula:
COUNTIFS(rng">="&start_time,rng,"<"&end_time) |
Syntaxt and Arguments
Rng:the time range that includes the times you count. |
Start_time, end_time:the time range that you want to count times between. |
Return Value
The formula returns a numeric value.
How this formula works
For example, in range B3:B10, there is a list of time records, and now you want to count the number of time records that in the specific time range from 2:30 (in cell E2) to 4:30 (in cell E3), please use below formula:
=COUNTIFS(B3:B10,">="&E2,B3:B10,"<"&E3) |
Press Enter key to return the result.
Explanation
COUNTIFS function: returns the number of cells that meet multiple criteria.
Relative Formulas
- Count Weekdays only Between Two Dates
This tutorial provides formulas to count the days excluding weekends and holidays between two dates - Count Specific Weekday Between Two Dates
This tutorial provides the formula to count a specific weekday between two given dates in Excel. - Count Days From Today
This tutorial provides the best formula to calculate the difference between a date and today in Excel. - Convert Weekday in A Date Range
If there is a list of dates, how can you count a certain day of week in such a list of dates?
Relative Functions
- Excel WEEKNUM Function
Returns the week number of the given date in a year - Excel WORKDAY Function
Adds workdays to the given start date and returns a workday - Excel MONTH Function
The MONTH is used to get the month as integer number (1 to 12) from date - Excel DAY Function
DAY function gets the day as a number (1 to 31) from a date - Excel NOW Function
Get the current time and date
The Best Office Productivity Tools
Kutools for Excel - Helps You To Stand Out From Crowd
Kutools for Excel Boasts Over 300 Features, Ensuring That What You Need is Just A Click Away...
Office Tab - Enable Tabbed Reading and Editing in Microsoft Office (include Excel)
- One second to switch between dozens of open documents!
- Reduce hundreds of mouse clicks for you every day, say goodbye to mouse hand.
- Increases your productivity by 50% when viewing and editing multiple documents.
- Brings Efficient Tabs to Office (include Excel), Just Like Chrome, Edge and Firefox.