I am constructing a macro. I need one of the formula's to pull in data from a report that will count any entries on the report after 07:00 a.m. This will need to be done daily which is why I cannot hard code a specific date. I have tried:

>TODAY 07:00

The date and time are in one column and I do not want to split into two columns (text to columns).

This is the entire string:

Range("AI7").Select
ActiveCell.FormulaR1C1 = _
"=COUNTIFS([DPA_ScheduledReport.csv]DPA_ScheduledReport!R[-4]C7:R[9994]C7,""success"",[DPA_ScheduledReport.csv]DPA_ScheduledReport!R[-4]C15:R[9994]C15,"">TODAY 07:00"")"

Everything else works.