Ok... hope this is what you meant.
The file shows the conditionally formatted Top Ranked values of 30% highlighted in green for each day. My goal is to have a way to note the time of day in the cell in column D. In other words, having it tell me 10:25 AM in D12.
Having an X or Y or something else works as well, because I can then simply sort D and then copy and paste the times into column E. I already created a formula that would count the times of day and tell me which times occur the most, but I need the data first. Thanks.
|