Count the number of occurrences between times (includes after midnight)

[frik]

Hi,

I have the data;

9:00 PM
12:00 AM
12:00 AM
4:00 PM
5:00 PM
1:00 PM
12:00 AM
10:00 PM

and I'd like to count the number of occurrences that fall between 8pm and 1230am.

So far =COUNTIFS(J5:J25,">=20:00",J5:J25,"<=24:30") is not giving me the correct result that is 5.

Please help! Thank you 🙏

[Pepe Le Mokko]

Welcome to the forum

As it is important to know if your data are real time or text looking like time ( format is not necessarily relevant),please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[Pepe Le Mokko]

Still using XL 2003 ?

[josephteh]

Try, =COUNTIFS(J5:J25,">=20:00")+COUNTIFS(J5:J25,"<=00:30")

[frik]

Welcome to the forum

As it is important to know if your data are real time or text looking like time ( format is not necessarily relevant),please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Ah thanks, sorry, I'll remember that next time.

[frik]

Try, =COUNTIFS(J5:J25,">=20:00")+COUNTIFS(J5:J25,"<=00:30")

This worked! Thank you.