Fill in a column

Question

I have a current workflow that feeds into an Excel file used for auditing purposes. We gather data files twice a day at 12AM and 10AM. I am trying to get the excel file output to check a 12AM column or 10AM column based on either a Q&A or by looking at the timestamp (If between 12AM and 9AM it pus an "x" in the 12AM column. If between 10AM and 12PM it puts an "x" in the 10AM column).

I have been stuck on this and cannot find the right tool or function to make this happen.

romanyurek · Answer

Actually I had to combine portions of each of your input. The reason the 10AM "X" would not show is because I was putting just greater than 10. What I needed to do was greater than or equal to.

That is working great now and I appreciate both of your input.

Qiu · Answer

@romanyurek 
I mocked the input data as you can see.

It will be good if you could provide us some sample from your real input, then we can know where is the problem.

romanyurek · Answer

Thank you. This worked partially. But when I RUN it only puts an "X" in the 12AM column and leaves the 10AM column blank. I am playing around with this now, but any advice would be helpful.