I have a table like the following:

A | B | C |
---|---|---|

123 | 24/05/2024 09:42:54 | |

123 | 24/05/2024 09:42:55 | 00:00:01 |

123 | 24/05/2024 09:42:56 | 00:00:01 |

123 | 24/05/2024 09:42:57 | 00:00:01 |

Where C is like `=b2-b1`

. The sheet has over 100,000 rows.

What I want to do is count all the entries in C where the value is `00:00:01`

, but when I try `COUNTIF(c1:c200000, "00:00:01")`

or `COUNTIF(c1:c200000, TIMEVALUE("00:00:01"))`

or `COUNTIF(c1:c200000, TIME(0,0,1))`

I get 0.00, when I can easily see the value must be greater than one.

How should I be counting the time difference?

If it's important I'm using Excel for Microsoft 365.