» Counting Time Values in Terms of Hourly Increments
CATEGORY - Excel Counting
VERSION - All Microsoft Excel Versions
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:
- PowerPoint® 2002 For Dummies®
- Dictionary of Finance and Investment Terms
- Rich Dad's Guide to Investing: What the Rich Invest in, That the Poor and the Middle Class Do Not!
- Who Moved My Cheese? An Amazing Way to Deal with Change in Your Work and in Your Life
- Business Plans Kit for Dummies (With CD-ROM)
- Retire Young, Retire Rich
No comments have been submitted.
Excel Formula and Function
Excel Date and Time
Excel Macros and VBA
Excel Text, Editing and Format
Excel General
Excel Data
