Excel 2007 : Checking if a time cell falls within a given time range

**Kashyash** · 05-21-2012, 04:54 PM

Hi all, this is my first post. Hope everyone's doing well

I'm having a problem that seems really trivial to solve, but I'm unable to figure it out. Here goes:

I have 2 columns A and P:

A P

0:23 00:30 - 02:30
1:32 02:30 - 04:30
1:34 04:30 - 06:30
1:55
2:09
2:21
2:43
2:53
4:04
4:25
5:08

I need to figure out how many in column A fall within the ranges of column P. I've tried using IF and that wont work, same with COUNTIF.
Any help would be appreciated a lot.

Thanks in advance!

**FDibbins** · 05-21-2012, 05:13 PM

if the contents of P1 (?) are "00:30 - 02:30" then you will have a hard time finding out is 1:32 falls within that range. this is because "00:30 - 02:30" is text, and 1:32 is more than likely a value

i will see what i can come up with for you

**Kashyash** · 05-21-2012, 05:36 PM

Ah, I see. Okay, so what if I were to place the range extrema in two different columns ? Like this:

A B C
0:23 0:30 2:30
1:32 2:30 4:30
1:34 4:30 6:30
1:55
2:09
2:21
2:43
2:53
3:20
3:37
4:04
4:25
5:08

Would that help ?