1

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:

=COUNTIF(TimeColumn, ">"&TIME(18,0,0))

This returns 0, whereas I expect about 11.

I have not been able to figure out how to set up this inequality.

What works:

  1. =COUNTIF(TimeColumn, TIME(18,0,0) returns 1, as expected.
  2. =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?

  • 1
    I haven't taken the time to experiment, but I suspect one workaround might be to convert the time values into plain numbers (which hopefully COUNTIF is happier with) using the TIMEVALUE function? I'm thinking: add another column calculating TIMEVALUE of your TIME values, then point COUNTIF at that new column. Hide the column if you don't want to see it. – Ashley Oct 25 '18 at 0:09
  • @Ashley Thanks! That’s what I ended up doing. It works, though I would have preferred to find a solution without this crutch. Would you like to convert your comment to an answer? – Philip Oct 25 '18 at 4:15

You must log in to answer this question.

Browse other questions tagged .