|
|
#1
09-30-2014, 12:21 PM
|
|||
|
|||
Greater than today at a specific time
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. 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Can you review status in Project from a previous time prior to "Today" | StevieMar | Project | 3 | 04-30-2014 09:42 AM |
| Auto Forward Emails - Specific Time Periods Only | Dav | Outlook | 0 | 06-22-2011 12:03 PM |
| how to make the task starts next day if no time enough today(task can not be split) | duraid | Project | 1 | 10-25-2010 08:31 AM |
| outlook 2000 pst greater than 2gb | bbxrider | Outlook | 0 | 09-25-2010 02:37 PM |
 If A1 greater than or equal to 1 Then A3 = A2*A1
|
brians | Excel | 5 | 03-09-2010 12:04 PM |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode