Spreadsheet: 155789d1337041833-outlook-calendar-export-max-min-on-conditionally-matched-range-outlooktemp
Sheet: OutLookParse

Data |  |  |  |  |  |  | Summary
STARTDATE | STARTTIME | ENDDATE | ENDTIME | SUBJECT | ALLDAYEVENT |  | DAY | START | END | NOTES
2007-10-09 00:00:00 | 12:50:00 | 2007-10-09 00:00:00 | 13:30:00 | Text123 | 0 |  | 2007-10-01 00:00:00 | 0:00 | 0:00
2007-10-03 00:00:00 | 08:30:00 | 2007-10-03 00:00:00 | 09:30:00 | Text100 | 0 |  | 2007-10-02 00:00:00 | 0:00 | 0:00
2007-10-03 00:00:00 | 08:00:00 | 2007-10-03 00:00:00 | 12:45:00 | Text102 | 0 |  | 2007-10-03 00:00:00 | 08:30:00 | 17:30:00 | Text102
2007-10-03 00:00:00 | 15:45:00 | 2007-10-03 00:00:00 | 16:05:00 | Text105 | 0 |  | 2007-10-04 00:00:00 | 0:00 | 0:00
2007-10-03 00:00:00 | 16:05:00 | 2007-10-03 00:00:00 | 17:30:00 | Text106 | 0 |  | 2007-10-05 00:00:00 | 08:30:00 | 0:00
2007-10-09 00:00:00 | 15:20:00 | 2007-10-09 00:00:00 | 17:00:00 | Text126 | 0 |  | 2007-10-06 00:00:00 | 0:00 | 0:00
2007-10-04 00:00:00 | 08:30:00 | 2007-10-04 00:00:00 | 09:45:00 | Text108 | 0 |  | 2007-10-07 00:00:00 | 0:00 | 0:00
2007-10-04 00:00:00 | 10:00:00 | 2007-10-04 00:00:00 | 12:00:00 | Text109 | 0 |  | 2007-10-08 00:00:00
2007-10-04 00:00:00 | 12:00:00 | 2007-10-04 00:00:00 | 13:30:00 | Text110 | 0 |  | 2007-10-09 00:00:00
2007-10-04 00:00:00 | 13:30:00 | 2007-10-04 00:00:00 | 15:15:00 | Text111 | 0 |  | 2007-10-10 00:00:00
2007-10-09 00:00:00 | 14:00:00 | 2007-10-09 00:00:00 | 15:00:00 | Text125 | 0 |  | 2007-10-11 00:00:00
2007-10-04 00:00:00 | 15:30:00 | 2007-10-04 00:00:00 | 16:15:00 | Text112 | 0 |  | 2007-10-12 00:00:00
2007-10-05 00:00:00 | 08:00:00 | 2007-10-05 00:00:00 | 11:00:00 | Text113 | 0
2007-10-09 00:00:00 | 11:30:00 | 2007-10-09 00:00:00 | 12:00:00 | Text121 | 0 |  | Notes:
2007-10-05 00:00:00 | 08:00:00 | 2007-10-05 00:00:00 | 08:30:00 | Text114 | 0 |  | START value needs to be minimum STARTTIME value for rows where DAY=STARTDATE, excluding any rows with SUBJECT value "Personal" or ALLDAYEVENT value of "TRUE"
2007-10-05 00:00:00 | 11:00:00 | 2007-10-05 00:00:00 | 11:30:00 | Text115 | 0 |  | START value should be 0:00 where no matching rows entries are found.
2007-10-10 00:00:00 | 09:30:00 | 2007-10-10 00:00:00 | 10:00:00 | Text130 | 0 |  | END Value should be maximum ENDTIME value where DAY=ENDDATE, excluding any rows with SUBJECT value of "Personal" and ALLDAYEVENT value of "TRUE"
2007-10-05 00:00:00 | 11:30:00 | 2007-10-05 00:00:00 | 14:45:00 | Text116 | 0 |  | NOTES value should be the corresponding SUBJECT value from the matching END ROW.
2007-10-05 00:00:00 | 1900-01-01 00:00:00 | 2007-10-05 00:00:00 | 1900-01-01 00:00:00 | Personal | 1 |  | DataTable is unsorted.
2007-10-05 00:00:00 | 15:30:00 | 2007-10-05 00:00:00 | 16:00:00 | Text118 | 0
2007-10-08 00:00:00 | 07:45:00 | 2007-10-08 00:00:00 | 15:30:00 | Text119 | 0 |  | Correct Example
2007-10-09 00:00:00 | 07:50:00 | 2007-10-09 00:00:00 | 11:30:00 | Text120 | 0 |  | DAY | START | END | NOTES
2007-10-03 00:00:00 | 13:00:00 | 2007-10-03 00:00:00 | 13:15:00 | Text103 | 0 |  | 2007-10-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | No matches
2007-10-03 00:00:00 | 1900-01-01 00:00:00 | 2007-10-03 00:00:00 | 1900-01-01 00:00:00 | Text104 | 1 |  | 2007-10-02 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | No matches
2007-10-09 00:00:00 | 12:00:00 | 2007-10-09 00:00:00 | 12:50:00 | Text122 | 0 |  | 2007-10-03 00:00:00 | 08:00:00 | 17:30:00 | Text106
2007-10-09 00:00:00 | 13:30:00 | 2007-10-09 00:00:00 | 14:00:00 | Text124 | 0 |  | 2007-10-04 00:00:00 | 08:30:00 | 16:15:00 | Text112 | Not 8:00 since that is marked as personal
2007-10-10 00:00:00 | 08:30:00 | 2007-10-10 00:00:00 | 09:00:00 | Text127 | 0 |  | 2007-10-05 00:00:00 | 08:00:00 | 16:00:00 | Text118
2007-10-04 00:00:00 | 08:00:00 | 2007-10-04 00:00:00 | 08:30:00 | Personal | 0 |  | 2007-10-06 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | No matches
2007-10-10 00:00:00 | 08:00:00 | 2007-10-10 00:00:00 | 08:30:00 | Text128 | 0 |  | 2007-10-07 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | No matches
2007-10-10 00:00:00 | 09:00:00 | 2007-10-10 00:00:00 | 09:30:00 | Text129 | 0 |  | 2007-10-08 00:00:00 | 07:45:00 | 15:30:00 | Text119
2007-10-03 00:00:00 | 15:30:00 | 2007-10-03 00:00:00 | 15:45:00 | Text101 | 0 |  | 2007-10-09 00:00:00 | 07:50:00 | 17:00:00 | Text126
 |  |  |  |  |  |  | 2007-10-10 00:00:00 | 08:00:00 | 10:00:00 | Text130
 |  |  |  |  |  |  | 2007-10-11 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
 |  |  |  |  |  |  | 2007-10-12 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00