## Excel greater than less than time

## Excel greater than less than time

(OP)

Hello, Im loooking for some help with a little project.

I have two cells with time formatted value that I need to get a count on. For example, cell C2 has a time of 5:00 in it and cell D2 has a time of 14;00 listed in it. From there, cells E1 through M1 have the time broken up hourly across them, such as E1 has 5:00, F1 has 6:00, and so on.

What Im looking for is to have a 1 listed in the corresponding cells beneath it, so something similar to the following

IF cell E1(5:00) is greater than cell C2(5:00) and less than cell D2(14:00), then cell E2 = 1

I hope this makes sense. Im on a tablet right now and cant show exactly what im trying to do right now but i will post a screenshot of it when i get back to my laptop. Just wanted to throw this out now to see what kind of help i can get.

I have two cells with time formatted value that I need to get a count on. For example, cell C2 has a time of 5:00 in it and cell D2 has a time of 14;00 listed in it. From there, cells E1 through M1 have the time broken up hourly across them, such as E1 has 5:00, F1 has 6:00, and so on.

What Im looking for is to have a 1 listed in the corresponding cells beneath it, so something similar to the following

IF cell E1(5:00) is greater than cell C2(5:00) and less than cell D2(14:00), then cell E2 = 1

I hope this makes sense. Im on a tablet right now and cant show exactly what im trying to do right now but i will post a screenshot of it when i get back to my laptop. Just wanted to throw this out now to see what kind of help i can get.

## RE: Excel greater than less than time

Any help is appreciated

## RE: Excel greater than less than time

I’m on my iPad, so this is untested.

Enter this into E2...

=IF(AND($C2<=E$1,$D2>=E$1),1,0)

Then COPY ‘n’ PASTE into all.

Skip,

_{ Just traded in my OLD subtlety... for a NUance!}## RE: Excel greater than less than time