This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I have a time where I want to count amount of instances (21:00 - 03:20 that something accoured in between times 23:20 - 01:10)
I used formula =COUNTIFS($P$3:$P$22,">="&Q2,$P$3:$P$22,"<"&R2) to bring me the value of it and it works fine till midnight and the formula gave up on working. Any idea what that would be and how can I get it fixed ?
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Could you link to a workbook with thisin it, failing that, could you change the format of all the cells showing times to General and give us a screenshot?
This is to establish what numbers are behind the time-formatted values.
=IF(R2<Q2,COUNTIFS($P$3:$P$22,">="&Q2,$P$3:$P$22,"<"&1)+COUNTIFS($P$3:$P$22,">="&0,$P$3:$P$22,"<"&R2),COUNTIFS($P$3:$P$22,">="&Q2,$P$3:$P$22,"<"&R2))
How did you fill the times in Q2:BC2 (or further)?