excelnovice19
New Member
- Joined
- Aug 22, 2011
- Messages
- 9
Hi all, i have a question that probably has a simple answer, but I can't figure this out. Worksheet columns A and B are empty. Whenever a number (1-4) is manually entered into a cell in column B, the corresponding cell in column A captures the time of entry in column B using the following formula: =IF(B1<>"",IF(A1="",NOW(),A1),""). This works fine. Now, I want to count all values that fall within two time periods in column A, that is, how many entries in column B were made between say 12:00 - 1:00 pm. For that I have this formula =SUMPRODUCT((A1:A60>=TIME(12,0,0))*(A1:A60<=TIME(12,59,0)))
Problem: the formula used to count the time values works perfectly fine if I enter the times manually into a given cell, but will not work when range include values generated by another formula as above. Hope that makes sense.
Can anyone tell me what I'm not includingin the second formula to make it work?
Thanks for the help!
Problem: the formula used to count the time values works perfectly fine if I enter the times manually into a given cell, but will not work when range include values generated by another formula as above. Hope that makes sense.
Can anyone tell me what I'm not includingin the second formula to make it work?
Thanks for the help!