Excel Forum
Similar Content
Calculate the Total Time Worked Minus Lunch Breaks in Excel
Tutorial: Ill show you how to use Excel to calculate the total time worked in a day minus lunch tim...
Input Form to Get Data and Store it in Another Tab in Excel
Tutorial: How to make a user input form in Excel and have the data stored on another worksheet at th...
Get the Day of the Week (1 to 7) for a Date in Excel - WEEKDAY
Tutorial: Use a function in Excel to get the number of the day in a week, from 1 to 7.  This allows...



Excel Magic Trick 441: Count Times That Start With 7 (7:00, 7:15, etc.)


See how to count the number of times in a list of times that begin with 7. Example 1:30, 7:00, 7:34, 6:00 would be a count of 2. See the functions HOUR, TEXT and SUMPRODUCT.





Got a Question? Ask it Here in the Forum.