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.

Category:

Science & Technology

Tags:

• Excel
• Count
• Times
• That
• Start
• With
• HOUR
• TEXT
• SUMPRODUCT
• excelisfun
• Mike
• Gel
• Girvin
• Highline
• Community
• College

[marketguro]

As always, great video tutorial. What if I have "Yes" or "No" on column B and I want to select only hour with "Yes" value? How do I add this to code?

[ExcelIsFun]

You Tube won't let me post the formula in the comment area - so I sent you an e-mail.

[marketguro]

Excel is a challenge for beginner like me but you make it FUN.Thank you very much.

[ExcelIsFun]

You are welcome!

Did you get my e-mail?

[marketguro]

Thanks for the E-mail.

[ExcelIsFun]

No problem.

[eissoaibrasil]

Thank you for your response to my question, those are all great videos that you suggested.

I will view them and see if they work for my situation.

Thanks again.

[ExcelIsFun]

Try these video titles:

Excel Busn Math 33: Stock Values Web Query & Rate Of Change

Excel Magic Trick #44: Web Query, % Change & Custom Number F

Excel Magic Trick #108: Exchange Rate Table From Web Query

[eissoaibrasil]

Great video as always! I have a linked spreadsheet that displays live stock market data. I need to extract data from each field as price increases or decrease and store it in a separate field, to show the relative change in High/Low. Is this possible in Excel?

Thanks for n e help u can give.