» Counting Time Values in Terms of Hourly Increments
CATEGORY - Excel Counting
VERSION - All Microsoft Excel Versions
Problem:Counting the number of time values in List1 (column A) that occur between each pair of successive hours listed in column B.
Solution:
Use the COUNTIF function as shown in the following formula:
=COUNTIF($A$2:$A$7,">"&B2)-COUNTIF($A$2:$A$7,">"&B3)
Book Store:
Recommended Books:
- Wall Street Journal Guide to Understanding Money and Investing
- Infectious Greed: How Deceit and Risk Corrupted the Financial Markets
- Mortgages For Dummies®
- The New Financial Order: Risk in the Twenty-First Century
- Treason: Liberal Treachery from the Cold War to the War on Terrorism
- Financial Statement Analysis with S&P insert card
No comments have been submitted.
