I have a La Crosse data logger that tracks temperature and humidity every 5
minutes. A sample of the raw data from download of the weather instrument
is:

"Date";"Indoor Temperature";"Indoor Humidity";"Outdoor Temperature
1";"Outdoor Humidity 1";"Outdoor Temperature 2";"Outdoor Humidity
2";"Outdoor Temperature 3";"Outdoor Humidity 3";"Outdoor Temperature
4";"Outdoor Humidity 4";"Outdoor Temperature 5";"Outdoor Humidity 5"
"2007-05-06
13:05";"74.1";"38";"53.0";"53";"---";"---";"---";"---";"---";"---";"---";"---"
"2007-05-06
13:10";"72.3";"39";"53.9";"53";"---";"---";"---";"---";"---";"---";"---";"---"
"2007-05-06
13:15";"71.0";"40";"53.9";"53";"---";"---";"---";"---";"---";"---";"---";"---"
"2007-05-06
13:20";"70.1";"41";"53.9";"54";"---";"---";"---";"---";"---";"---";"---";"---"
"2007-05-06
13:25";"70.1";"41";"53.9";"54";"---";"---";"---";"---";"---";"---";"---";"---"
"2007-05-06
13:30";"69.6";"41";"53.9";"54";"---";"---";"---";"---";"---";"---";"---";"---"
"2007-05-06
13:35";"69.4";"42";"56.3";"54";"---";"---";"---";"---";"---";"---";"---";"---"
"2007-05-06
13:40";"69.4";"42";"56.3";"53";"---";"---";"---";"---";"---";"---";"---";"---"
"2007-05-06
13:45";"69.2";"42";"57.5";"53";"---";"---";"---";"---";"---";"---";"---";"---"

I edited each of the above to provide time separate from date, thus:
"2007-05-06";"13:45";"69.2";"42";"57.5";"53";"---";"---";"---";"---";"---";"---";"---";"---"

I then used their "export" of the above after editing each (per example
above) into Excel 2000. This gives me ( headings done manually):

Date Time Indoor Outdoor
Temp Humid Temp1 Humid1
5/6/2007 13:05 74.1 38 53 53
5/6/2007 13:10 72.3 39 53.9 53
5/6/2007 13:15 71 40 53.9 53
5/6/2007 13:20 70.1 41 53.9 54
5/6/2007 13:25 70.1 41 53.9 54
5/6/2007 13:30 69.6 41 53.9 54
5/6/2007 13:35 69.4 42 56.3 54
5/6/2007 13:40 69.4 42 56.3 53
5/6/2007 13:45 69.2 42 57.5 53

From that I want to display the data as shown below:

Indoor Temperature Indoor Humidity
Outdoor Temperature Outdoor Humidity
Date Time Max Time Min Time Max Time Min Time Max
Time Min Time Max Time Min
5/6/2007 13:05 74.1 13:45 69.2 13:35 42 13:05 38 13:45 57.5
13:05 53.0 13:35 54 13:05 53

How can I automate this process on a daily basis? Macro's? Some kind of
programming? I used 'Sort' to find the Maximums and Minimums with the
corresponding times then copied and pasted but it take too long and prone to
errors.

Any suggestions will certainly be appreciated,

Bill Snow