Count time entries between different hours

Closed
Gouws Posts 45 Registration date Sunday February 7, 2010 Status Member Last seen April 15, 2012 - Apr 15, 2012 at 04:30 AM
 Josh - Apr 16, 2012 at 10:08 AM
Hello,

I am trying to count time entries between different hours. I've tried a couple of formulas but so far every formula i've tried does not seem to count the right amount of entries. I would appreciate it if someone can assist with a formula.

I have time entries in row F, eg:01:15:00 AM (F10),01:25:00 AM (F11), 01:45:00 (F12), 02:00:00 AM (F13), 02:05:00 AM (F14).

The formula i'm looking for must then count the amount of entries >= 01:00:00 AM and <02:00:00 AM and also >=02:00:00 AM and <03:00:00 AM.
01:00:00 AM - 02:00:00 AM = 3 (answer needed - number)
02:00:00 AM - 03:00:00 AM = 2 (answer needed - number)

Thanks



Related:

1 response

=COUNTIFS(1:1,">=2:00:00 AM",1:1, "<3:00:00 AM")

Just change the ranges and times to fit your criteria. 1:1 is for row 1.

Good luck.
0