techguy2010
Technical User
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.
![[glasses]](/data/assets/smilies/glasses.gif "[glasses] [glasses]")
Just traded in my OLD subtlety...![[tongue]](/data/assets/smilies/tongue.gif "[tongue] [tongue]")