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 allow...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



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.