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,
for a NUance!
RE: Excel greater than less than time