I am using the latest version of Apple Numbers on iOS.
I have a table with a Date/Time column, with values being:
=TIME(0,0,0) =TIME(0,30,0) =TIME(1,0,0)
and so on, in half-hour increments, for the entire day.
Now I want to count how many rows have a time greater than 18:00, so I try this:
This returns 0, whereas I expect about 11.
I have not been able to figure out how to set up this inequality.
=COUNTIF(TimeColumn, TIME(18,0,0)returns 1, as expected.
=TIME(18,30,0) > TIME(18,0,0)returns TRUE, as expected.
How do I count up the number of rows with a time greater than (or greater-than-or-equal-to) some constant time?